Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tables in Parent-Child Order

Re: Tables in Parent-Child Order

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Mar 2006 10:00:57 -0800
Message-ID: <1142013657.708159.315800@i39g2000cwa.googlegroups.com> 





pankaj, the problem with you question is that a sinle table may have
several FK reationships defined to other tables.  Technically each of
these is a parent.



You can find this information by joining the DBA_CONSTRAINTS to itself
using the r_constaint_name = constraint_name



This will give you the tables that have a FK to the table of interest.



HTH -- Mark D Powell --
Received on Fri Mar 10 2006 - 12:00:57 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US