Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!texbell!swbatl!wuarchive!cs.utexas.edu!samsung!brutus.cs.uiuc.edu!apple!oracle!news
From: corpspt@oracle.com (David E. Anderson)
Newsgroups: comp.databases
Subject: Re: Retrieval of hierachical record in relational model
Keywords: SQL Oracle heirarchical relationships
Message-ID: <1990Mar3.001731.11927@oracle.com>
Date: 3 Mar 90 00:17:31 GMT
References: <637@usdpyr.ACUSD.EDU>
Reply-To: danderso@oracle.com (David E. Anderson)
Followup-To: comp.databases
Distribution: usa
Organization: Oracle Corporation, Belmont CA
Lines: 20

In article <637@usdpyr.ACUSD.EDU> news@usdpyr.ACUSD.EDU (news) writes:
>I am working on school project. My question concerns how to build and access 
>the multi-level hierachical record in the Oracle's relational model.
>Any feedback will be appreciated.
>
>Allen Tsai
>University of San Diego
>Internet : tsai@usdcsv.acusd.edu
>BITNET : tsai@acusd 

Allen,

Use the CONNECT BY and START WITH clauses; they are provided for this purpose.
Both are described in the SQL*Plus User's Guide, V2.0 (for RDBMS V5) and the
SQL Language Reference Manual (for RDBMS V6).

David

David E. Anderson
( as of March 9, 1990, independent consultant, ANDERSON@WELL.UUCP)