December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_OUTLN.DROP_BY_CAT
(cat VARCHAR2);
Drops outlines of category cat.
PROCEDURE DBMS_OUTLN.DROP_COLLISION;
Drops an outline with an OL$.HINTCOUNT that does not match the number of hints for the outline in OL$HINTS.
PROCEDURE DBMS_OUTLN.DROP_EXTRA;
Drops extra hint rows not accounted for by OL$.HINTCOUNT.
PROCEDURE DBMS_OUTLN.DROP_UNREFD_HINTS;
Drops hint rows that have no corresponding outline in the OL$ table.
PROCEDURE DBMS_OUTLN.DROP_UNUSED;
Drop outlines generated by an application for one-time use only.
PROCEDURE DBMS_OUTLN.UPDATE_BY_CAT
(oldcat VARCHAR2 DEFAULT 'DEFAULT',
newcat VARCHAR2 DEFAULT 'DEFAULT');
Changes the category of all outlines in oldcat to newcat.
PROCEDURE DBMS_OUTLN.GENERATE_SIGNATURE
(sqltxt IN VARCHAR2,
signature OUT RAW);
Generates a signature for sqltext.