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!

Extracting table names, dblinks etc. from sql string

a_yavuzJan 19 2010 — edited Jan 19 2010
Hi,

I would like ask if there is an example or any knowledge about extracting table names from an sql string using regex.

Ex.

sqlstr := 'SELECT * FROM schema1.table1@dblk1, shema2.table2@dblk2 WHERE ...'

I need to extract schema names, table names and dblinks. How oracle extract these parameters while creating execution plan.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2010
Added on Jan 19 2010
10 comments
3,953 views