Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: column length, range of values and ........ decode???

Re: column length, range of values and ........ decode???

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sat, 25 Jan 2003 17:11:29 -0800
Message-ID: <3E3335C1.7C2BA402@exesolutions.com>


Sybrand Bakker wrote:

> On Sat, 25 Jan 2003 07:15:08 -0800, DA Morgan
> <damorgan_at_exesolutions.com> wrote:
>
> >Right concept wrong function. Use CASE rather than DECODE as in the
> >following example:
>
> This might not apply to the version the OP is using, and he doesn't
> mention the version he uses. I think you are on thin ice here!
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Not as thin as DECODE. And it will work in either 8i or 9i. Though in 8i it will require using NDS.

Mike will have to pay the price for his omission.

Daniel Morgan Received on Sat Jan 25 2003 - 19:11:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US