Re: Question on Hierarchy

Oh yes: I'll bet you never saw a sub-query used inside a NVL function, eh?
It works and very well.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:73e20c6c.0308192242.2fe3f007_at_posting.google.com...
> SQL> select


>   2  nvl((select 'Y' from dual where exists

>   3      (select 1 from zot

>   4       where f2 = 'd'

>   5       connect by prior f2 = f1

>   6       start with f1 = 'a')),'N')

>   7  from dual;