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

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I find the related columns?

Re: How can I find the related columns?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 11 Nov 2004 22:39:19 -0800
Message-ID: <1100241482.422299@yasure>


D. Alvarado wrote:

> Hello, I'm running Oracle 8.1.7 enterprise server on Solaris. I
> wanted to find all the tables/columns that link through a foreign key
> to a column in my table, A.COL1. How would i build a query to achieve
> this?
>
> Thanks, -

http://www.psoug.org
click on Morgan's Library
click on constraints
scroll to the SQL statements at the bottom of the page.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Nov 12 2004 - 00:39:19 CST

Original text of this message

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