Check user dependencies for a given table : user_dependencies « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. user_dependencies

Check user dependencies for a given table

    
SQL> select name, type,
  2   referenced_name, referenced_type
  3   from user_Dependencies
  4   where name = 'EMP_MAINT'
  5  /

no rows selected

SQL>








Related examples in the same category

1.Query user_dependencies for cross references
2.Check dependencies for procedure
3.Check package reference
4.Who referenced current user's objects