Re: DECODE AND SELECT

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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno

Re: DECODE AND SELECT

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

DECODE AND SELECT

Hi I am in urgent need of backporting oracle9i pl/sql to oracle8i.I have encountered some case satements like this CASE when x0 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

Re: DECODE AND SELECT

, hrishy wrote: Hi I am in urgent need of backporting oracle9i pl/sql to oracle8i.I have encountered some case satements like this CASE when x0 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

RE: DECODE AND SELECT

need to convert them to decode statements.Can anybody tell me how to write a select statement within decode. regards Hrishy Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http