Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
10g Release 2 (10.2)

Part Number B14258-02
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

67 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 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



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 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.



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 67-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 67-4 REFRESH_PRIVATE_OUTLINE Procedure Parameters

Parameter Description

name

Name of the private outline to be refreshed.