Oracle Database

Not sure how many DBAs have noticed the difference between DBA_TAB_COLUMNS view and DBA_TAB_COLS view. Both views look pretty identical, if you are not paying too much attention. According to Oracle documentation, DBA_TAB_COLS describes the columns of all tables, views, and clusters in the database. This view differs from “DBA_TAB_COLUMNS” in that system-generated hidden columns … Read more

Oracle Database DBMS_UTILITY package has several useful subprograms. GET_DEPENDENCY shows the objects depended on the object. Here is an example (the procedure uses DBMS_OUTPUT to show the result, hence SET SERVEROUTPUT is required in SQL*Plus): SQL> set serveroutput on SQL> exec dbms_utility.get_dependency(‘VIEW’,’HR’,’EMP_DETAILS_VIEW’); – DEPENDENCIES ON HR.EMP_DETAILS_VIEW —————————————————————— *VIEW HR.EMP_DETAILS_VIEW() PL/SQL procedure successfully completed. SQL> exec … Read more