Two Cool Utilities in DBMS_UTILITY

by

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

Great Lakes Oracle Conference – Presentation Download

by

NEOOUG did a wonderful job in organizing the Great Lakes Oracle Conference event and the venue. This was the first time me doing two presentations in one conference, that too, for two different type of audience. E-Business Suite R12 Upgrade and Oracle Database 12c New Features. I want to thank Sybex for sending the newly published … Read more