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

  DROP OUTLINE ---> <outline-name> -+---------------+->
                                    +-> IF EXISTS --+

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;