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

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. Received on Wed Nov 28 2007 - 00:12:19 CST