Geek Answers Handbook

Are there any parsers for Oracle DML table_reference?

Or is there any oracle data dictionary to tell me which tables are referenced in (both) views?

I want to know what table links are used in DML. I prefer to use the oracle package, as it may be standalone in the database.

But other suggestions are welcome. Open source is welcome.

Here is a link to the syntax diagram for defining table_reference: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2126863

Are there any parsers?

+1
source share
2 answers

Venkataramesh (dba_snapshots) , / . , USER_DEPENDENCIES:

select name, type, referenced_name, referenced_type
from user_dependencies
where type = 'MATERIALIZED VIEW'
order by name
0

dba_snapshots. , , / .

0

More articles:


All Articles