Oracle DML table_reference是否存在任何解析器? [英] Do any parsers exist for the Oracle DML table_reference?

问题描述

或者是否有任何Oracle数据字典可以告诉我在(非分类)视图中引用了哪些表?

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

我希望找出DML中使用了哪些表引用.我更喜欢使用oracle软件包，因为它可以自我包含在数据库中.

I wish to find out what tables references are used in a DML. I prefer to use an oracle package as it can be self contained in the database.

但是其他建议也欢迎.开源非常欢迎.

But other suggestions welcome. Open source very welcome.

这是table_reference定义的语法图的链接: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2126863

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

是否存在任何解析器?

推荐答案

当快照涉及多个表和/或视图时，Venkataramesh的答案(dba_snapshots)仅提供部分答案-要获取所涉及对象的完整列表，请使用USER_DEPENDENCIES视图:

Venkataramesh's answer (dba_snapshots) only provides part of the answer when the snapshots involve multiple tables and/or views - to get the full list of objects involved you can use the USER_DEPENDENCIES view:

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

这篇关于Oracle DML table_reference是否存在任何解析器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！