Databases Reference
In-Depth Information
Source Code Depot
Table 21-3 lists this chapter's source files and their functionality.
Table 21-3.
DBMS_UTILITY Source Code Depot
File Name
Functionality
name_resolve.sql
This script contains an anonymous block that resolves the
name of any object type supported by the procedure
DBMS_
UTILITY.NAME_RESOLVE
.
name_resolve_procedure.sql
This script creates a stored procedure called
NAME_RESOLVE
.
The procedure resolves all the object types supported by
DBMS_UTILITY.NAME_RESOLVE
. The procedure
NAME_RESOLVE
accepts the same parameters as the packaged procedure
DBMS_UTILITY.NAME_RESOLVE
, tries all contexts, and if successful,
returns the same information as
DBMS_UTILITY.NAME_RESOLVE
.
Additionally, it returns the qualified resolved name. Individual
components of the resolved name are returned in double
quotes, to preserve case sensitivity.
name_resolve_table.sql
Example of name resolution of a table with
DBMS_UTILITY
.
statistics.sql
This script reports optimizer statistics for table and index
columns. Used for checking column selectivity and indexing
when tuning SQL statements.
