Re: Does anyone have a script to display hierarchy of tables starting with a specific one

Oops. The line below should read: You can't do it in a single query because following the hierarchy requires a
> CONNECT BY query, which CANNOT be used in the same statement as a join.
In other words, the connect by has to be done first.

Sisk, David [YRK:6J00:EXCH] <dsisk_at_americasm01.nt.com> wrote in message news:8athja$ndm$1_at_zrtph05m.us.nortel.com...
> Nope. You can write a recursive stored procedure to output the info
 though.
> You can't do it in a single query because following the hierarchy requires
 a
> CONNECT BY query, which can be used in the same statement as a join.
 Guess
> what, the DBA views all do joins.
>
> You can construct a view that performs a CONNECT BY query, then another
> query or view that performs a join to the results of the connect by, so it
> might be possible to do a CONNECT BY on the base dictionary tables to get
> the hierarchy, then join that result set to the necessary object names.
> Unfortunately, I've never tried this.
>
> Good luck,
> D.
>
Received on Fri Mar 17 2000 - 00:00:00 CST