PL/SQL Packages DBMS_OUTLN_EDIT

Update an Oracle Outline.

Subprocedures:

CHANGE_JOIN_POS     Change the join position for the hint identified by outline name
                    and hint number to the position specified by newpos. 

CREATE_EDIT_TABLES  Create outline editing tables in a calling user's schema.  

DROP_EDIT_TABLES    Drop outline editing tables in the calling user's schema. 

REFRESH_PRIVATE_OUTLINE 
                    Refresh the in-memory copy of the outline, synchronizing its
                    data with the edits made to the outline hints.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:

Related Views:

 DBA_OUTLINES                              USER_OUTLINES 
 DBA_OUTLINE_HINTS                         USER_OUTLINE_HINTS 



 
Copyright © 1999-2024 SS64.com
Some rights reserved