Oracle7 SQL - start with/connect by

Hello,

        In Oracle7 SQL, there is a construct
[Quoted] "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
[Quoted] e-mail: nagaraj_jyothi_at_isus.emc.com Received on Wed Jan 29 1997 - 00:00:00 CET