dba:oracle:oracle_sql_querys:objects
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
oracle:oracle_sql_querys:objects [2019/07/18 07:17] – external edit 127.0.0.1 | dba:oracle:oracle_sql_querys:objects [2022/02/11 11:12] – ↷ Page moved from oracle:oracle_sql_querys:objects to dba:oracle:oracle_sql_querys:objects dodger | ||
---|---|---|---|
Line 433: | Line 433: | ||
WHERE TABLE_NAME LIKE ' | WHERE TABLE_NAME LIKE ' | ||
; | ; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ==== List VIEW dependencies ==== | ||
+ | |||
+ | <code sql> | ||
+ | COL SCHEMA_NAME FORMAT A40 | ||
+ | COL REFERENCED_SCHEMA_NAME FORMAT A40 | ||
+ | COL REFERENCED_NAME FORMAT A40 | ||
+ | col REFERENCED_TYPE | ||
+ | |||
+ | select owner as schema_name, | ||
+ | name as view_name, | ||
+ | | ||
+ | | ||
+ | | ||
+ | from sys.dba_dependencies | ||
+ | where type = ' | ||
+ | -- AND OWNER=' | ||
+ | -- and name LIKE ' | ||
+ | order by owner, name, referenced_name, | ||
+ | / | ||
</ | </ | ||