Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: case when ... then expression

Re: case when ... then expression

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 25 Jun 2001 23:03:37 +0100
Message-ID: <993506455.24077.2.nnrp-14.9e984b29@news.demon.co.uk>

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>...

>
>What's wrong with DECODE? That is the PL/SQL equivalent.
>
>Daniel A. Morgan
>
Received on Mon Jun 25 2001 - 17:03:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US