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
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
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
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
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
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
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
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
Hi Jared,
Here is an example -
The following part of unix script does not work-
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]>
10 matches
Mail list logo