Re: Querying Hierarchical Table

From: Lubomir Petrov <lpetrov_at_yahoo.com>
Date: 21 Dec 2001 13:01:27 -0800
Message-ID: <75805ad9.0112211301.2e69cc09@posting.google.com>

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 - 15:01:27 CST