Re: leaf rows

From: Hexathioorthooxalate <ruler_at_removemetoemail.clara.co.uk>
Date: Wed, 2 Mar 2005 10:21:16 -0000
Message-ID: <1109758876.46769.0@dyke.uk.clara.net>

If you are using 10g, there is the pseudorow CONNECT_BY_ISLEAF. If you are using 9i, you will have to determine whether the row is a leaf or not yourself. What version of Oracle are you using?

A brief and informative description of hierarchical query 10g enhancements can be found here.

http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/gennick_connectby_10g.html

Hex

"Cris Carampa" <cris119_at_operamail.com> wrote in message news:42259183$0$32347$5fc30a8_at_news.tiscali.it...
> Giving a hierarchical query as an inline view, is there a way to identify
> leaf rows via SQL?
>
> Thank you. Kind regards,
>
> --
> Cris Carampa (cris119_at_operamail.com)
>
> - We're gonna be like three little Fonzies here. And what's Fonzie like?
> - Cool?
>
>
Received on Wed Mar 02 2005 - 04:21:16 CST