List objects that use specific object in Oracle database

Article for: SQL Server Azure SQL Database

Query below lists all objects that are referencing to specific object .


select owner || '.' || name as referencing_object,
       type as referencing_type,
       referenced_owner || '.' || referenced_name as referenced_object,
from sys.all_dependencies
where referenced_name = 'object_name'  -- put your object name here
      --and referenced_owner = 'schema name'
order by referencing_object;

Note. If there is more objects with the same name uncomment referenced_owner clause


  • referencing_object - provided object name with schema name
  • referencing_type - type of provided object
  • referenced_object - name and schema of the referenced object
  • referenced_type - type of referenced object


  • One row represents one depending object
  • Scope of rows: all objects that are depending on specified object
  • Ordered by referencing object schema name and name

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.