Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to use 'Case' in Oracle 8i
pal wrote:
> On Nov 28, 9:06 am, DA Morgan <damor..._at_psoug.org> wrote:
> > > 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.orgReceived on Wed Nov 28 2007 - 01:19:33 CST