Re: Nice present, only discovered for Christmas

Michel Cadot wrote:
>
> "Mladen Gogala" <gogala_at_sbcglobal.net> a écrit dans le message de news: pan.2005.12.25.09.14.47.965344_at_sbcglobal.net...
> | On Sun, 25 Dec 2005 09:55:50 +0100, Michel Cadot wrote:
> |
> | > PL/SQL procedure successfully completed.
> | >
> | > =?/? SCOTT>select * from v$version;
> | > BANNER
> | > ----------------------------------------------------------------
> | > Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production PL/SQL
> | > Release 9.2.0.6.0 - Production Regards
> | > Michel Cadot
> |
> | OK, I am stoopid. When did this happen? When did Oracle make available
> | analytic functions within PL/SQL? I distinctly remember having problems
> | with that. Not that I am complaining, but Oracle should have told us, this
> | is a big change for the better.
> |
> | --
> | http://www.mgogala.com
> |
>
> "Oracle9i Database Release 1 (9.0.1) New Features",
> "PL/SQL Improvements",
>
> <quote>
> ...
> Other technological advances to PL/SQL include the following new features:
>
> * Integrated front-end for SQL compilation so that PL/SQL immediately supports all SQL syntax changes to embedded SQL.
> ...
> </quote>
>
> Regards
> Michel Cadot

Try using NVL2 in SQL... Then try it in PLSQL

:-)

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------