Re: how to use 'Case' in Oracle 8i

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 27 Nov 2007 23:19:33 -0800
Message-ID: <1196234366.119279@bubbleator.drizzle.com>

pal wrote:

> On Nov 28, 9:06 am, DA Morgan <damor..._at_psoug.org> wrote:

>> pal wrote:
>>> On Nov 27, 11:00 am, DA Morgan <damor..._at_psoug.org> wrote:
>>>> pal wrote:
>>>>> Can any one tell me how can i use Case in Oracle 8i...
>>>>> thanks and regards
>>>> In SQL just use it.
>>>> In PL/SQL with native dynamic SQL.
>>>> Assuming, by 8i, you mean 8.1.7 and not 8.1.5.
>>>> --
>>>> Daniel A. Morgan
>>>> Oracle Ace Director & Instructor
>>>> University of Washington
>>>> damor..._at_x.washington.edu (replace x with u to respond)
>>>> Puget Sound Oracle Users Groupwww.psoug.org
>>> Morgan it is 8.1.5
>> Then it does not exist.
>>
>> Are you aware of just how archaic 8.1.5 is? Let me help you if
>> you are not. It was introduced in 1999: 8 years ago. There are
>> children in 3rd grade that aren't as old as your software.
>> --
>> Daniel A. Morgan
>> Oracle Ace Director & Instructor
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>
>> - Show quoted text -

> 
> 
> Mr ,Morgan , whatever it is,
> i just want to know is there any alternative for this case statements,
> which i can use in 8.1.5
> 
> cos some of out clients are still using the version,
> and according to their requirements i want to deliver the product.

Most of what people use CASE for can be done with DECODE. Look at the examples in Morgan's Library at www.psoug.org under DECODE and CASE. Pay special attention to the use of SIGN in some of the demos.

It isn't pretty but it works very well.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Nov 28 2007 - 01:19:33 CST