Re: Querying Hierarchical Table

From: Martin Haltmayer <Martin.Haltmayer_at_d2mail.de>
Date: Sat, 22 Dec 2001 00:10:01 +0100
Message-ID: <3C23C149.15B616D9@d2mail.de>

Good hint. However, the original poster did not mention the version s/he tried to run.

Regards,

Martin

Lubomir Petrov wrote:
>
> Hi,
>
> You can use SYS_CONNECT_BY_PATH() function to display the hierarchy in
> one line.
>
> See Oracle SQL Reference
> (http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/functions118.htm#88362)
>
> Regards
> Lyubomir Petrov
>
> sweidanz_at_yahoo.com wrote in message news:<ScaS7.15$i%2.4019_at_nsw.nnrp.telstra.net>...
> > I tried to use start with and connect by clause, but it does not help in
> > displaying the hierarchy in one line.
> > any other ideas?
> >
> > Thanks,
> > ZS
Received on Fri Dec 21 2001 - 17:10:01 CST