©Mike Moxcey 1999

Close_Flag Step 2

Need both options CHECKED appropriately.

select seq,
decode (close_date,'','Checked',''),'No ',
decode (close_date,'','','Checked'),'Yes'
from oratut.calls where seq in (3,4);
should work.



home next