Skip to Main Content

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!

How to find DB tables containing specific columns (ORG_ID / ORGANIZATION_ID)

2885671Apr 16 2015 — edited Apr 16 2015

Hi All, I would like to know if someone developed a script to find all tables containing specific columns(fields).


I'm on a migration project where I do not have access to the source DB, I just can ask for queries and I have to mirror all the DB tables containing specific Organization data.

So the first step was to understand used tables and I get them, now I want to understand what tables have Org_id / Organization_ID, and LANGUAGE/SOURCE LANGUAGE fields (the source DB have many Org's defined and many languages also, so I need to filter 6ORG_ID of 100total, and 2 languages of 8 total installed)

Can someone help?

Thank you

Best Regards

Pietro

This post has been answered by MF-Oracle on Apr 16 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2015
Added on Apr 16 2015
7 comments
17,756 views