How to get the common columns name from multiple tables

This will help you out to find the links between tables…..

SELECT column_name FROM all_tab_cols
where table_name =’PO_HEADERS_ALL’ — Table Name 1
INTERSECT
SELECT column_name FROM all_tab_cols
WHERE table_name =’PO_LINES_ALL’ — Table Name 2
INTERSECT
SELECT column_name FROM all_tab_cols
WHERE table_name =’PO_DISTRIBUTIONS_ALL’ — Table Name 3

And so on …..

This entry was posted in Oracle, Oracle E-Business Suite.

Leave a Reply

Your email address will not be published. Required fields are marked *