1  –  correlation_name

    Specifies a name that identifies the table or view in the
    predicate of the DELETE statement. See the User_Supplied_Names
    HELP topic for more information about correlation names.

2  –  CURRENT_OF

    If the WHERE clause uses CURRENT OF cursor-name, SQL deletes only
    the row on which the named cursor is positioned.

    The cursor must have been named previously in a DECLARE CURSOR
    statement, must be open, and must be positioned on a row. In
    addition, the FROM clause of the SELECT statement within the
    DECLARE CURSOR statement must refer to the table or view that is
    the target of the DELETE statement.

3  –  OPTIMIZE_AS

    Assigns a name to the query.

4  –  OPTIMIZE_FOR

    The OPTIMIZE FOR clause specifies the preferred optimizer
    strategy for statements that specify a select expression. The
    following options are available:

    o  FAST FIRST

       A query optimized for FAST FIRST returns data to the user as
       quickly as possible, even at the expense of total throughput.

       If a query can be cancelled prematurely, you should specify
       FAST FIRST optimization. A good candidate for FAST FIRST
       optimization is an interactive application that displays
       groups of records to the user, where the user has the option
       of aborting the query after the first few screens. For
       example, singleton SELECT statements default to FAST FIRST
       optimization.

       If optimization strategy is not explicitly set, FAST FIRST is
       the default.

    o  TOTAL TIME

       If your application runs in batch, accesses all the records in
       the query, and performs updates or writes a report, you should
       specify TOTAL TIME optimization. Most queries benefit from
       TOTAL TIME optimization.

    o  SEQUENTIAL ACCESS

       Forces the use of sequential access. This is particularly
       valuable for tables that use the strict partitioning
       functionality.

5  –  OPTIMIZE_USING

    Names the query outline to be used with the DELETE statement
    even if the outline ID for the query and for the outline are
    different.

    A query outline is an overall plan for how a query can be
    implemented. See the CREATE OUTLINE statement for additional
    information.

6  –  OPTIMIZE_WITH

    Selects one of three optimization controls: DEFAULT (as used by
    previous versions of Oracle Rdb), AGGRESSIVE (assumes smaller
    numbers of rows will be selected), and SAMPLED (which uses
    literals in the query to perform preliminary estimation on
    indices).

7  –  predicate

    If the WHERE clause includes a predicate, all the rows of the
    target table for which the predicate is true are deleted. See the
    Predicates HELP topic for more information on predicates.

8  –  table-name

    Specifies the name of the target table from which you want to
    delete a row.

9  –  view-name

    Specifies the name of the view from which you want to delete a
    row.

10  –  WHERE

    Specifies the rows of the target table or view that will be
    deleted. If you omit the WHERE clause, SQL deletes all rows of
    the target table or view. You can specify either a predicate or a
    cursor name in the WHERE clause.