SQL> r 1 select seq, decode(close_date,'', 'Open','Closed') 2* from oratut.calls where seq in (3,4) SEQ DECODE ---------- ------ 3 Open 4 Closed