The
DROP_BY_CAT procedure has the name of the category as its only input parameter. The
following example drops all the outlines within the DEVELOPMENT category:
execute DBMS_OUTLN.DROP_BY_CAT('DEVELOPMENT');
To reassign outlines from an old category to a new category, use the UPDATE_BY_CAT
procedure, as shown in the following example:
execute OUTLN_PKG.UPDATE_BY_CAT -
(oldcat => 'DEVELOPMENT', -
newcat => 'TEST');
To drop a specific outline, use the drop outline command.
If you have imported outlines generated in an earlier release, use the UPDATE_SIGNATURES
procedure of DBMS_OUTLN to ensure the signatures are compatible with the current release??™s
computation algorithm.
Editing Stored Outlines
You can use DBMS_OUTLN_EDIT to edit the stored outlines. The procedures within DBMS_
OUTLN_EDIT are detailed in the following table:
Procedure Description
CHANGE_JOIN_POS Changes the join position for the hint identified by outline
name and hint number to the position specified. Inputs are
name, hintno, and newpos.
CREATE_EDIT_TABLES Creates outline editing tables in the user??™s schema.
DROP_EDIT_TABLES Drops the outline editing tables in the user??™s schema.
GENERATE_SIGNATURE Generates a signature for the specified SQL text.
REFRESH_PRIVATE_OUTLINE Refreshes the in-memory copy of the outline, synchronizing it
with the edits made.
NOTE
As of Oracle 10g, you no longer need to execute the CREATE_EDIT_
TABLES procedure because the edit tables are available as temporary
tables in the SYSTEM schema.
Pages:
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263