SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

All tables containing a common column

AswathyJKApr 9 2013 — edited Apr 9 2013

Hi,
Is there any way to find the list of tables having a common column by sql query?
for eg: Suppose I have a column ID in table A and table B.My query should return both tableA and ~table B since ID is present in both tables
Regards
Aswathy

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2013

Added on Apr 9 2013

7 comments

578 views