UPDATE_BY_CAT Procedure

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.

Syntax

DBMS.OUTLN.UPDATE_BY_CAT ( 
   oldcat VARCHAR2 DEFAULT 'DEFAULT', 
   newcat VARCHAR2 DEFAULT 'DEFAULT');

Parameters

Table 37-3 UPDATE_BY_CAT Procedure Parameters

Parameter	Description
oldcat	Current category to be changed.
newcat	Target category to change outline to.

Usage Notes

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.

Example

This example changes all outlines in the DEFAULT category to the CAT1 category:

DBMS_OUTLN.UPDATE_BY_CAT('DEFAULT', 'CAT1');