Oracle® Database PL/SQL Packages and Types Reference 10g Release 2 (10.2) Part Number B14258-01 |
|
|
View PDF |
The DBMS_OUTLN_EDIT
package is an invoker's rights package.
See Also:
For more information about using theDBMS_OUTLN_EDIT
package, see "Using Plan Stability" in Oracle Database Performance Tuning Guide.This chapter contains the following topic:
Table 67-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 |
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 67-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. |
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.
This procedure drops outline editing tables in calling the user's schema.
Syntax
DBMS_OUTLN_EDIT.DROP_EDIT_TABLES;
This procedure generates a signature for the specified SQL text.
Syntax
DBMS_OUTLN.GENERATE_SIGNATURE ( sqltxt IN VARCHAR2, signature OUT RAW);
Parameters
Table 67-3 GENERATE_SIGNATURE Procedure Parameters
Parameter | Description |
---|---|
sqltxt |
The specified SQL. |
signature |
The signature to be generated. |
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