Skip to Main Content
Forums

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 get a list of table names from a query?

506350Aug 11 2010 — edited Aug 12 2010
Hello,

I am using Oracle 10g. I have around 100 SQL queries stored in a table. I would like to know if there is an easy way to extract the source tables in each query.
For example:
I have a query "SELECT * FROM Table1 t1 INNER JOIN Table2 t2 ON t1.col1=t2.col1
From this query I would like to automatically get the list of the tables:
Table1
Table2

Thank you in advance for your cooperation.

Best regards,
Beroetz
This post has been answered by SomeoneElse on Aug 11 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2010
Added on Aug 11 2010
12 comments
2,806 views