Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does anyone have a script to display hierarchy of tables starting with a specific one
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.
Eric <ebektech_at_videotron.ca> wrote in message
news:n3dA4.41$585.157570_at_news.magma.ca...
> based on the fk-pk relationship...
>
> example:
> employee
> dept
> store
> marital_status
> address
> country
> .
> .
> .
>
>
>
Received on Fri Mar 17 2000 - 00:00:00 CST