Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_OUTLN , 7 of 8
This procedure changes the category of all outlines in one category to a new category. If the SQL text in an outline already has an outline in the target category, it is not merged into the new category.
DBMS.OUTLN.UPDATE_BY_CAT ( oldcat VARCHAR2 DEFAULT 'DEFAULT', newcat VARCHAR2 DEFAULT 'DEFAULT');
Parameter | Description |
---|---|
oldcat |
Current category to be changed. |
newcat |
Target category to change outline to. |
Once satisfied with a set of outlines, you can move outlines from an experimental category to a production category. Likewise, you may want to merge a set of outlines from one category into another pre-existing category.
This example changes all outlines in the DEFAULT
category to the CAT1
category:
DBMS_OUTLN.UPDATE_BY_CAT('DEFAULT', 'CAT1');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|