Re: Possible to use Decode or Count function on PL SQL Table?

From: Douglas Hawthorne <DouglasHawthorne_at_yahoo.com.au>
Date: Mon, 26 Jan 2004 21:39:03 GMT
Message-ID: <XNfRb.29426$Wa.26048@news-server.bigpond.net.au>

Daniel,

However, the searched condition form of the CASE statement was introduced in 9.0.1. So the CASE statements I gave in my reply will not parse in 8i.

Douglas Hawthorne
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1075151623.107380_at_yasure...
> Mags wrote:
>
> > Thanks for your reply. I'm actually using Oracle 8i so I haven't come
> > across the CASE statement you've used below.
>
> CASE works in 8i but must be nested in native dynamic SQL.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon Jan 26 2004 - 15:39:03 CST