| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: EASY ? Case statement
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
Received on Wed Nov 08 2000 - 01:16:47 CST
 |
 |