Advertisement

DBMS_Utility

  • Norbert Debes

Abstract

Most of the functions and procedures of the PL/SQL package DBMS_UTILITY are sufficiently documented. The procedure NAME_RESOLVE accepts the name of a database object and decomposes the name into its constituent parts, such as a schema, an object name, and potentially a database link. According to Oracle Database PL/SQL Packages and Types Reference 10g Release 2, the procedure supports the four object types: synonym, procedure, function, and package. Actual testing reveals that it supports a total of eight object types, thus extending its usefulness.

Keywords

Database Object Data Dictionary Block Block Cost Base Optimiz Context Number 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations