Re: How to list all childs elements

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 04 Jan 2007 08:21:10 -0800
Message-ID: <1167927671.145464@bubbleator.drizzle.com>

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 Thu Jan 04 2007 - 10:21:10 CST