Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_OUTLN_EDIT , 2 of 2


Summary of DBMS_OUTLN_EDIT Subprograms

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

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 42-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;

DROP_EDIT_TABLES Procedure

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

Syntax

DBMS_OUTLN_EDIT.DROP_EDIT_TABLES;

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 42-3 REFRESH_PRIVATE_OUTLINE Procedure Parameters
Parameter Description

name

Name of the private outline to be refreshed.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback