Re: DECODE

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Thu, 01 Apr 2004 22:51:55 GMT
Message-ID: <f21bc.3877$dW5.507@edtnps89>

Brian Peasland wrote:

<snip>
> If you are using Oracle 9i, then you most likely want to implement the
> CASE function instead of DECODE. If you are pre-9i, then you will most
> likely want to code this as a stored function and reference the function
> in your SELECT statement.
>
> HTH,
> Brian
>

I thought that the CASE statement did not work in pl/sql in 8i. Perhaps I have that backwards? I know is works in plain sql. Received on Thu Apr 01 2004 - 16:51:55 CST