Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:oracle:oracle_sql_querys:objects

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
oracle:oracle_sql_querys:objects [2019/07/18 07:17] – external edit 127.0.0.1dba:oracle:oracle_sql_querys:objects [2022/02/11 11:36] – external edit 127.0.0.1
Line 19: Line 19:
  
 See:  See: 
-[[oracle:recompile_it_all|[SCRIPT] Recompile all database objects]]+[[dba:oracle:recompile_it_all|[SCRIPT] Recompile all database objects]]
  
 ===== DBMS_METADATA ===== ===== DBMS_METADATA =====
Line 433: Line 433:
 WHERE TABLE_NAME LIKE '%TABLE_NAME%' WHERE TABLE_NAME LIKE '%TABLE_NAME%'
 ; ;
 +</code>
 +
 +
 +==== List VIEW dependencies ====
 +
 +<code sql>
 +COL SCHEMA_NAME FORMAT A40 
 +COL REFERENCED_SCHEMA_NAME FORMAT A40 
 +COL REFERENCED_NAME FORMAT A40 
 +col REFERENCED_TYPE  format a30 
 +
 +select owner as schema_name,
 +       name as view_name,
 +       referenced_owner as referenced_schema_name,
 +       referenced_name,
 +       referenced_type
 +from sys.dba_dependencies
 +where type = 'VIEW'
 +-- AND OWNER='OWNER'
 +-- and name LIKE '%VIEW_NAME%'
 +order by owner, name, referenced_name, referenced_owner, referenced_type
 +/
 </code> </code>