Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 1 (11.1)

Part Number B28419-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

86 DBMS_OUTLN_EDIT

The DBMS_OUTLN_EDIT package is an invoker's rights package.

See Also:

For more information about using the DBMS_OUTLN_EDIT package, see "Using Plan Stability" in Oracle Database Performance Tuning Guide.

This chapter contains the following topic:


Summary of DBMS_OUTLN_EDIT Subprograms

Table 86-1 DBMS_OUTLN_EDIT Package Subprograms

Subprogram Description
CHANGE_JOIN_POS Procedure
Changes the join position for the hint identified by outline name and hint number to the position specified by newpos
CREATE_EDIT_TABLES Procedure
Creates outline editing tables in calling a user's schema
DROP_EDIT_TABLES Procedure
Drops outline editing tables in calling the user's schema
GENERATE_SIGNATURE Procedure
Generates a signature for the specified SQL text
REFRESH_PRIVATE_OUTLINE Procedure
Refreshes the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints


CHANGE_JOIN_POS Procedure

This function changes the join position for the hint identified by outline name and hint number to the position specified by newpos.

Syntax

DBMS_OUTLN_EDIT.CHANGE_JOIN_POS (
   name     VARCHAR2
   hintno   NUMBER
   newpos   NUMBER);

Parameters

Table 86-2 CHANGE_JOIN_POS Procedure Parameters

Parameter Description
name Name of the private outline to be modified.
hintno Hint number to be modified.
newpos New join position for the target hint.


CREATE_EDIT_TABLES Procedure

This procedure creates outline editing tables in calling a user's schema.

Syntax

DBMS_OUTLN_EDIT.CREATE_EDIT_TABLES;

Usage Notes

Beginning with Oracle Database 10g Release 1 (10.1) you will not need to use this statement because the outline editing tables will already exist as temporary tables in the SYSTEM schema.


DROP_EDIT_TABLES Procedure

This procedure drops outline editing tables in calling the user's schema.

Syntax

DBMS_OUTLN_EDIT.DROP_EDIT_TABLES;

GENERATE_SIGNATURE Procedure

This procedure generates a signature for the specified SQL text.

Syntax

DBMS_OUTLN.GENERATE_SIGNATURE ( 
   sqltxt      IN   VARCHAR2, 
   signature   OUT  RAW);

Parameters

Table 86-3 GENERATE_SIGNATURE Procedure Parameters

Parameter Description
sqltxt The specified SQL.
signature The signature to be generated.


REFRESH_PRIVATE_OUTLINE Procedure

This procedure refreshes the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints.

Syntax

DBMS_OUTLN_EDIT.REFRESH_PRIVATE_OUTLINE ( 
   name  IN  VARCHAR2);

Parameters

Table 86-4 REFRESH_PRIVATE_OUTLINE Procedure Parameters

Parameter Description
name Name of the private outline to be refreshed.