Re: DECODE AND SELECT

Oracle 8i (8.1.6+) PL/SQL can use execute immediate for SQL with searched CASE expressions.

Have Fun :)

Nuno Souto wrote:

>----- Original Message -----
>
>
>
>>I am in urgent need of backporting oracle9i pl/sql to
>>oracle8i.I have encountered some case satements like
>>this
>>
>>CASE
>>when x>0 then (select y from deptno)
>>else
>>(select Z from emp)
>>end
>>
>>i need to convert them to decode statements.Can
>>anybody tell me how to write a select statement within
>>decode.
>>
>>
>
>You already got some suggestions. But if you're
>backporting from 9i to 8i, don't bother:
>8i supports CASE happily. At least in SQL...
>
>Cheers
>Nuno Souto
>nsouto_at_optusnet.com.au
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chip
  INET: ocp-dba_at_earthlink.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).