Deletes a query outline.
1 – Environment
You can use the DROP OUTLINE statement:
o In interactive SQL
o Embedded in host language programs to be precompiled
o As part of a procedure in an SQL module
o In dynamic SQL as a statement to be dynamically executed
The DROP OUTLINE statement allows the user to specify that an
existing outline should be removed from the database.
2 – Format
(B)0[m[1;4mDROP[m[1m [1;4mOUTLINE[m[1m qqq> <outline-name> qwqqqqqqqqqqqqqqqwq>[m [1m mq> [1;4mIF[m[1m [1;4mEXISTS[m [1mqqj[m
3 – Arguments
3.1 – IF_EXISTS
Prevents SQL command language from displaying error messages if
the referenced object does not exist in the database.
3.2 – outline-name
Specifies the name of the outline you want to delete.
4 – Examples
Example 1. Deleting an outline
SQL> DROP OUTLINE MY_OUTLINE;