Awarded Member of the Month (June) by Oracle APEX Community

Here I am giving an example to find where specific table or view is used in oracle database Query 1: All objects where specific table or view accessible to the current user is used in Oracle database. SELECT  referenced_owner        ||  ‘.’        || referenced_name  AS  table_name ,        referenced_type     AS   TYPE ,         owner        ||  ‘.’        ||  …

Awarded Member of the Month (June) by Oracle APEX Community Read More »