Delete removes rows that satisfy the where clause from the table to which range_variable refers. If no where clause is specified, all rows are deleted.

To reduce the overhead required to execute a frequently repeated delete, specify repeat delete. Repeat directs the DBMS Server to encode the delete and save its execution plan. Program variables that change each time the query is executed and that appear on the right-hand side of an equal sign (=) must be preceded by the @ sign.

The delete statement fires any rules that is fired by an equivalent SQL delete statement. For more information, see the SQL Reference Guide.