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 revisionBoth sides next revision
oracle:oracle_sql_querys:objects [2019/07/18 07:17] – external edit 127.0.0.1oracle:oracle_sql_querys:objects [2020/07/17 07:49] – [Listar foreign keys de una tabla] dodger
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>