Hello,
I need to write the following decode statement and I am having trouble getting it right:
if an end_date is null or less than today then return X, else return Y.
Can anyone help,
Thanks in advance,
Boris Volf
Printable View
Hello,
I need to write the following decode statement and I am having trouble getting it right:
if an end_date is null or less than today then return X, else return Y.
Can anyone help,
Thanks in advance,
Boris Volf
Example:
Code:ccreate table test_decode(a date, b number);
insert into test_decode (a, b) values(trunc(sysdate-5),1);
insert into test_decode (a, b) values(trunc(sysdate+5),2);
insert into test_decode (a, b) values(to_date(null),3);
SQL> select sysdate, a, b, decode(a,null,'X',decode(sign(a-sysdate),-1,'X','Y'))
from test_decode;
2
SYSDATE A B D
--------- --------- ---------- -
18-NOV-02 23-NOV-02 2 Y
18-NOV-02 3 X
18-NOV-02 13-NOV-02 1 X
use case
something like
Code:select
case
when end_date is null
or end_date < trunc(sysdate)
then 'X'
else 'Y'
end end_date
from table;