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, Here

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-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] cc:

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

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] wrote:

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

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 CASE

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 I

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 PROTECTED]