©Mike Moxcey 1999

DECODE Test 2

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


home next