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
DBA_OUTLINES USER_OUTLINES DBA_OUTLINE_HINTS USER_OUTLINE_HINTS
© Copyright SS64.com 1999-2013
Some rights reserved