Object被其他的Object引用的SQL
一個Object(Table,view)被其他的Object(View,Procedure,Function,Package)引用的時候，
可以透過如下SQL查詢
假設 Table A別其他的物件引用，SQL如下：
select * from all_DEPENDENCIES where referenced_name='WIP'
select * from dba_objects where object_name like '%USER_DEPENDENCIES%'
可以透過如下SQL查詢
假設 Table A別其他的物件引用，SQL如下：
select * from all_DEPENDENCIES where referenced_name='WIP'
select * from dba_objects where object_name like '%USER_DEPENDENCIES%'
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24237320/viewspace-1980041/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- JavaScript中的Object的引用型別JavaScriptObject型別
- 引用型別之Object型別Object
- 引用型別之 Object（三）型別Object
- JavaScript引用型別-Object型別JavaScript型別Object
- SQL：OBJECT_ID和OBJECTPROPERTYSQLObject
- Uncaught TypeError: Object [object Object] has no method 'xxx'ErrorObject
- MXRuntimeUtils，替代 [NSObject performSelector object object ]的工具ObjectperformSelector
- TypeScript 中令人迷惑的物件型別：Object、{} 和 objectTypeScript物件型別Object
- object_id 與data_object_id 的區別Object
- object_id與data_object_id的關係Object
- objectObject
- OBJECT_ID、DATA_OBJECT_ID與truncate的本質Object
- 介面返回[object,Object]解決方法Object
- Effective Object C 2.0 『熟悉Object C』Object
- Object物件的屬性Object物件
- object.defineproperty 的用法Object
- Object()的方法一覽Object
- 神奇的 Object.definePropertyObject
- OBJECT_ID的重用Object
- Oracle中object_id和data_object_id的區別OracleObject
- ES7 Object.keys,Object.values,Object.entriesObject
- OBJECT_ID和DATA_OBJECT_IDObject
- data_object_id 及 object_id 的聯絡與區別Object
- Object流Object
- Object類Object
- 其它 ObjectObject
- object in javascriptObjectJavaScript
- Authorization ObjectObject
- Javascript中的Object.defineProperty()JavaScriptObject
- 關於new Object的探究Object
- Object上的靜態方法Object
- 【轉】Object類的常用方法Object
- Object與Class的關係Object
- 理解Object.defineProperty的作用Object
- 獲取Object物件的lengthObject物件
- 查詢Authorization Object的方法Object
- OBJECT_ID的重用（二）Object
- v$sql.object_status=INVALID_UNAUTHSQLObject