Re: data extraction based on primary key/foreign key constraints
Date: 5 Apr 2002 00:58:27 -0800
Message-ID: <f99e10b9.0204050058.73991e9f_at_posting.google.com>
Not really what I'm after.
I can get a list of the tables related by way of the all_constraints/all_cons_columns views. The problem I have is being able to select related data from all the tables. It seems to get quite tricky selecting data from the various tables when navigating up & down the related hierarchy of tables.
The main problem seems to be selecting data from the child tables. For
example
if the hierarchy of tables was taba-tabb-tabc I can select the data
from taba based on its primary key, but once I've selected from taba I
need to identify the values needed for selection of tabb details by
way of the foreign key constraint, and similarly I need to identify
the values from tabb for tabc selection. This needs to be done for
each row.
Hope this makes sense Received on Fri Apr 05 2002 - 10:58:27 CEST