Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!newsranger.com!www.newsranger.com!not-for-mail
Newsgroups: comp.databases.oracle.server
From: Roman Mirzaitov<rmirzaitov@kt.kg>
References: <6XxR7.95$th2.406@nsw.nnrp.telstra.net>
Subject: Re: Querying Hierarchical Table
Lines: 11
Message-ID: <SfER7.58540$xS6.95167@www.newsranger.com>
X-Abuse-Info: When contacting newsranger.com regarding abuse please
X-Abuse-Info: forward the entire news article including headers or
X-Abuse-Info: else we will not be able to process your request
X-Complaints-To: abuse@newsranger.com
NNTP-Posting-Date: Wed, 12 Dec 2001 03:08:18 EST
Organization: http://www.newsranger.com
Date: Wed, 12 Dec 2001 08:08:18 GMT
Xref: easynews comp.databases.oracle.server:127915
X-Received-Date: Wed, 12 Dec 2001 01:46:47 MST (news.easynews.com)

Hi,

I think that using "hierarchical query clause" of SELECT statement will be
useful in your case. For details see Oracle SQL Referemce.

Good luck,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com