12 Replies Latest reply on Aug 12, 2010 7:14 AM by 506350

    How to get a list of table names from a query?

    506350
      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