Re: EASY ? Case statement

True, there are several problems with
PL/SQ: not keeping up with SQL
(which should be eliminated by the
new embedding strategy in 9).

The standard work around is to open
a 'ref cursor' under 'execute immediate' to get at the data.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison Wesley Longman
Book bound date now 8th Dec 2000

Marc Billiet wrote in message <20001108.7164757_at_slu40xxx.hae.hydro.com>...
But unfortunately not in pl/sql...

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-11-02, 11:59:59, schreef Connor McDonald
<connor_mcdonald_at_yahoo.com> over het thema Re: EASY ? Case statement:



> 8.1.6 and above has "case" support..

 


> eg

 


> SELECT AVG(CASE WHEN e.sal > 2000 THEN e.sal ELSE 2000 END) from emp e;





> HTH

> --

> ===========================================

> Connor McDonald