Oracle Database

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

Unified Auditing is a new feature introduced in Oracle Database 12c, to streamline and standardize all audit trail information. The traditional auditing architectures involve many audit-trail locations and tables to review information for the auditors, and do not follow a standard. Every new product introduced in the database had to essentially have a new audit table … Read more