Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to list all childs elements
dear Daniel A. Morgan
Thanx for your kind help.
Kishan Thakker
DA Morgan wrote:
> kishanthakker_at_gmail.com wrote:
>
> > I studied the page you suggested for query of tree in Oracle, but it is
> > for oracle 9i as database. If it has to be solved in oracle 8 as
> > database do we have any alternative? I suppose 'CONNECT BY' clause in
> > not available in oracle 8.
>
> Rather than supposing ... read the docs. Your supposition is incorrect.
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/sql_elem.htm#9547
> --
> 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
Received on Mon Jan 08 2007 - 03:15:24 CST