Version?
select case when substr(banner, instr(banner,
'Release')+length('Release')+1, 1) < 9 then
'tough luck. sql and pl/sql parsers are different'
else 'check the syntax' end
from v$version where banner like 'Oracle%';
Thanks,
Boris Dali.
--- "Pillai, Rajesh" <[EMAIL PROTECTED]>
wrote: > Hi All,
> Any clues on why does a CASE block does not work in
> an INSERT-APPEND-SELECT statement called in a sql
> block in an UNIX script? If I replace the case block
> with a decode function then it works!!!! Whereas in
> a sql command prompt, both DECODE and CASE yields
> results.
>
> TIA for all ur hints.
>
> Thanks,
> Rajesh
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Pillai, Rajesh
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
