OracleNotes TidBits – May 2014

According to the dictionary, meaning of “tidbit” is “a small and particularly interesting item of gossip or information“… hope you find the “Oracle TidBits” published at https://www.facebook.com/oraclenotes interesting… Here is a compilation of the tidbits published in May 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the … Read more

Two Cool Utilities in DBMS_UTILITY

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