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 -> Master/Detail links: Where in system tables???

Master/Detail links: Where in system tables???

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/08/11
Message-ID: <871316104.24297@dejanews.com>#1/1

I am working on a utility to access a master table and its detail tables automatically, so I need to query Oracle's system tables to determine which columns are used to link a detail table to its master table. Is there such a system table in Oracle that stores this data?

I have little experience with master/detail links and referential integrity. Anyone's help will be greatly appreciated!

Steve Cosner

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Mon Aug 11 1997 - 00:00:00 CDT

Original text of this message

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