©Mike Moxcey 1999

Close_Flag Step 2 test


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

home next