Re: Direct and indirect foreign key relationships in SQL or Pl/Sql

From: <Dale_at_DataBee.com>
Date: Thu, 19 Dec 2002 02:14:28 -0800
Message-ID: <F001.0051DEF7.20021219021428@fatcity.com>

> How do I find out the direct and indirect foreign key relationships?
> Say, for example there are four tables A, B, C and D of which A is the
> parent table and B, C and D are child tables. Say B and C are related to
A
> directly and D is related to A through C. How do I find out this indirect
> relationship apart from the direct relationships? Any help in this regard
> is very much appreciated.

The DataBee software has a Chain Finder tool in the Set Designer which displays exactly this. DataBee is designed to create referentially correct subsets of Oracle databases and isn't free. However we do offer a 30 day evaluation which might enable you to get done what you want to do. If you would like to have a go at it drop me a note and I'll arrange to get an eval key over to you.

Here's a link to the Chain Finder help page - it has a nice picture of the relationship display.
http://www.databee.com/sdchainfinder.htm

Regards
Dale

---

Quickly and easily create test and development databases with DataBee. http://www.DataBee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Dale_at_DataBee.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Dec 19 2002 - 04:14:28 CST