User Tools

Site Tools


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 revision Previous revision
oracle:oracle_sql_querys:objects [2019/07/18 07:17]
127.0.0.1 external edit
oracle:oracle_sql_querys:objects [2020/07/17 07:49] (current)
dodger [Listar foreign keys de una tabla]
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>
  
oracle/oracle_sql_querys/objects.txt ยท Last modified: 2020/07/17 07:49 by dodger