SQL> select seq, decode (close_date,'','Checked',''),'No ', decode (close_date,'','','Checked'),'Yes' from oratut.calls where seq in (3,4); SEQ DECODE( 'NO DECODE( 'YE ---------- ------- --- ------- --- 3 Checked No Yes 4 No Checked Yes