sakthikumar
asked on
Any simpler way to avoid case
select case when d.arn_no is not null then to_char(d.arn_no)
when d.boe_no is not null then d.boe_no
else d.do_no end
from docs d
Is there any other simpler way without using case.?
when d.boe_no is not null then d.boe_no
else d.do_no end
from docs d
Is there any other simpler way without using case.?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.