dba_dependencies scripts
set lines 132
select distinct
owner,
name,
referenced_name
from
dba_dependencies
where
type in ('PACKAGE BODY','PROCEDURE','TRIGGER')
and
referenced_type = 'SEQUENCE';
select
referenced_name,
referenced_type
from
dba_dependencies
where
name='my_tablename';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23895263/viewspace-693838/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- shell scripts
- Sql scriptsSQL
- Oracle DBA ScriptsOracle
- Tuning Scripts
- Data Server ScriptsServer
- 神奇的npm -- scriptsNPM
- 清理日誌 scripts
- Rman Scripts (Linux)Linux
- oracle cold backup scriptsOracle
- DP rman backup scripts
- npm scripts 使用指南NPM
- Oracle EBS Monitoring ScriptsOracle
- 使用elasticsearch,Elasticsearch Scripts disabledElasticsearch
- linux_root_scriptsLinux
- RMAN 備份策略 scripts
- npm package.json scriptsNPMPackageJSON
- Scripts to resize standby redolog files
- oracle9i SQL ScriptsOracleSQL
- 5.npm scripts 使用指南NPM
- 你真的熟悉 npm-scripts 嗎?NPM
- npm scripts的生命週期管理NPM
- 什麼是 WEbExtend Scripts for Emarsys?Web
- RMAN progress and what it is waiting for scriptsAI
- Oracle Advanced Performance Tuning ScriptsOracleORM
- Top DBA Shell Scripts for Monitoring the DatabaseDatabase
- 你真的瞭解npm-scripts嗎?NPM
- Oracle Advanced Performance Tuning Scripts(轉)OracleORM
- 學習 Shell Scripts(轉載鳥哥)
- 如何查詢儲存過程procedure所依賴物件的有效性--dba_dependencies儲存過程物件
- PostgreSQL DBA(147) - pgAdmin(Scripts for freeze)SQL
- npm scripts設定環境變數方法NPM變數
- Common Diagnostic Scripts for AUM problems (Doc ID 746173.1)
- Step 9: Run Scripts to Build Data Dictionary Views (67)UIView
- 也許你不知道的npm-scriptsNPM
- vscode commitlint(debug npm scripts)VSCodeMITNPM
- 清空系統日誌shell scripts——自學筆記筆記
- AUM Common Analysis/Diagnostic Scripts (Doc ID 877613.1)
- Element package.json 中的 scripts 分析 —— "build:file"PackageJSONUI