Oracle if/else in results
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