Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Query to show parent to child tables in order
Ha...Ban Spam....thanks for the answer, but I was hoping for a single SQL
query solution against the Oracle system tables. Figured it wouldn't be
that easy. But Tom Kyte has an interesting solution that looks fine.
"Ban Spam" <ban-spam_at_operamail.com> wrote in message
news:Xns912478FAA13F8SunnySD_at_24.0.3.73...
> "DFS" <nospam_at_nospam.com> wrote in
> news:ON3r7.6474$W83.618707_at_newsread2.prod.itd.earthlink.net:
>
> > So....
> >
> > I have an Oracle db with many relations defined between tables. Is
> > there a way to construct a query (possibly from DBA_TABLES or
> > USER_TABLES or USER_CONS_COLUMNS, etc) that will return a list of
> > tables ordered top to bottom from parent to child?
> >
> >
> > Thanks,
> > Darryl
> >
>
> I suspect that it can be accomplished via SMOP
> (Small Matter Of Programming) that utilizes a
> recursive call in the programming language of
> choice that both can access Oracle & supports
> recursive calls; such as Perl, PL/SQL, JAVA, etc.
>
Received on Sat Sep 22 2001 - 23:43:17 CDT