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

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)