Output another word instead of the word in the table in a query Suppose I have a table where I have a field which can have to values: "enabled" and "disabled".
Suppose want my query to output "unblocked" instead of "enabled" and "blocked" instead of "disabled". How to do that in Oracle?
Either use the SQL standard way of CASE WHEN ... as ypercybe suggested in the comments or for more neat result, DECODE function:

DECODE(fieldref, 'enabled', 'unblocked', 'disabled', 'blocked')