Oracle if/else in results Just wondering if there's a way of doing something like the below in Oracle, where if a returned result is one value you output one thing, else you output something else?

For example:

select if(COL1,1:'TRUE',0:'FALSE') from TABLE1;


Thanks in advance C
SQL&gt; create table t1 (c1 number);

Table created.

SQL&gt; insert into t1 values(1);

1 row created.

SQL&gt; insert into t1 values(0);

1 row created.

SQL&gt; commit;

Commit complete.

SQL&gt; select decode(c1, 1, 'TRUE', 0, 'FALSE') from t1;

DECOD
-----
TRUE
FALSE