©Mike Moxcey 1999

DECODE Test 2

select seq,
decode(close_date,'', 'Open','Closed')
from oratut.calls where seq in (3,4);

should show Open if date is null
else should show Closed.

TEST and VERIFY!




home next