RE: SQL CASE Statement

2003-12-30 Thread Whittle Jerome Contr NCI
Title: RE: SQL CASE Statement I prefer the milk and candle method but that only works with flat panel displays.  ;-) Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From:   Poras, Henry R. [SMTP:[EMAIL PROTECTED] You

RE: SQL CASE Statement

2003-12-30 Thread Poras, Henry R.
You forgot to squeeze the lemon juice on your monitor. Henry -Original Message- Jared Still Sent: Tuesday, December 30, 2003 1:35 AM To: Multiple recipients of list ORACLE-L Is is just me, or is the code missing? On Mon, 2003-12-29 at 16:24, Pillai, Rajesh wrote: > Hi Jared, > Her

RE: SQL CASE Statement

2003-12-29 Thread Jared Still
Is is just me, or is the code missing? On Mon, 2003-12-29 at 16:24, Pillai, Rajesh wrote: > Hi Jared, > Here is an example - > The following part of unix script does not work- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTE

Re: SQL CASE Statement

2003-12-29 Thread Nuno Souto
If you are in 8i, then it won't work. Only after 9i is the SQL and PL/SQL SQL engine the same. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > 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

Re: SQL CASE Statement

2003-12-29 Thread Tanel Poder
In 9i, the codebase should be the same, so syntax should be "portable". Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 30, 2003 2:44 AM > Hi: > > Sql and pl/sql use different engine internally. I found this is true for

Re: SQL CASE Statement

2003-12-29 Thread David Hau
In 8i, CASE is supported in SQL but not PL/SQL. In 9i, it's supported on both. Workaround is to use dynamic SQL ("execute immediate"), or upgrade to 9i. Regards, Dave [EMAIL PROTECTED] wrote: Hi All, Any clues on why does a CASE block does not work in an INSERT-APPEND-SELECT statement ca

Re: SQL CASE Statement

2003-12-29 Thread Boris Dali
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]> wr

Re: SQL CASE Statement

2003-12-29 Thread Guang Mei
Hi: Sql and pl/sql use different engine internally. I found this is true for "CASE" in oracle 8i. HTH. Guang On Mon, 29 Dec 2003, Pillai, Rajesh 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 sc

RE: SQL CASE Statement

2003-12-29 Thread Pillai, Rajesh
Hi Jared, Here is an example - The following part of unix script does not work-

Re: SQL CASE Statement

2003-12-29 Thread Jared . Still
It would be easier to help if you supply an example that will reproduce the problem. Jared "Pillai, Rajesh" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  12/29/2003 03:39 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>