Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: case when ... then expression
First I don't think you can do:
m_variable := decode(....);
and that may have been the requirement.
Second it's a pain in the backside using decode() with range tests, as required by the original post.
Third
CASE
is new, improved, fresh out of the box,
technology ;)
-- Jonathan Lewis Host to The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html Seminars on getting the best out of Oracle See http://www.jlcomp.demon.co.uk/seminar.html Daniel A. Morgan wrote in message <3B379E72.B52177A1_at_attws.com>...Received on Mon Jun 25 2001 - 17:03:37 CDT
>
>What's wrong with DECODE? That is the PL/SQL equivalent.
>
>Daniel A. Morgan
>