Re: Oracle7 SQL - start with/connect by

Hi:

        Just change the position of prior viz:

1. connect by parent = prior child change this to
2. connect by prior parent = child

I hope this helps

Pankaj
pgarg_at_ahcpr.gov

Jyothi Nagaraj (nagaraj_jyothi_at_isus.emc.com) wrote:
: Hello,
 

: In Oracle7 SQL, there is a construct
: "start with - connect by" which allows you
: to select rows in a hierarchical order from
: a table that contains hierarchical data.
: This selects successive generations of child
: rows with respect to a parent row.
: Is there any way to select all
: parent rows, when you specify a child row?
: (basically get the reverse hierarchy)
 

: Thanks,
: Jyothi
: e-mail: nagaraj_jyothi_at_isus.emc.com
Received on Wed Jan 29 1997 - 00:00:00 CET