Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Recursive Queries

Re: Recursive Queries

From: Gerard M. Averill <e-mail.address_at_my.sig>
Date: Tue, 27 Apr 99 22:41:18 GMT
Message-ID: <7g5e4q$10fc$1@news.doit.wisc.edu>


In article <37261D84.19D7AF13_at_geopak.com>, Paul Schrum <Paul_at_geopak.com> wrote:

<snipped details of problem>

Paul, first read up on Oracle's extended SELECT syntax to facilitate just these types of hierarchical queries. See the section "Hierarchical Queries" under the SELECT command documentation in "Oracle7 Server SQL Reference Manual".

The concepts are quite straight-forward and you'll have no problem doing what you outlined in your post. Hope this helps.

Gerard



Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison GAverill<at>chsra<dot>wisc<dot>edu Received on Tue Apr 27 1999 - 17:41:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US