Re: NVL2 in PL/SQL 10g

klabu wrote:
> I *think* I have looked at NVL2 page on PSOUG site (which usually gets
> 1st-page google hit, as you may know)
>
> Anyway I think, before I ran out of patience, and thinking to myself
> "wow this is unbelievable !"
> I looked at at least 10 sites from google result and Quest's "PL/SQL
> Knowledgebase" and found
>
> NOT ONE SINGLE one points out the simple truth that
>
> *** NVL2 CAN NOT BE USED IN PL/SQL (ASSIGNMENT) ***
>
> They ALL show the same old "SELECT NVL2(......) FROM........"
>
> Maybe they all copied from each other in this case.

I will update the PSOUG site today with a demo that shows this.

Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org