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!

Parsing query and getting list of tables used

Mahendran-OracleJan 2 2014 — edited Jan 2 2014

Hi All,

   I require to parse sql query (simple & complex as well) and to get the list of tables used in the query.

   And need to validate that, the list of tables against a whitelist to maintained in the file.

  I tried to write my own parser, since there are lots possible ways to write complex queries, i am unable to cover all the scenarios.

  I require a help, Is there any other ways to get the list of tables used in a query?

Thanks,

Mahendran..

This post has been answered by Karthick2003 on Jan 2 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2014
Added on Jan 2 2014
26 comments
3,485 views