You can use the
DELETE command available in the SQL language in SPL programs.
You can use an expression in the SPL language wherever an expression is allowed in the SQL
DELETE command. Thus, you can use SPL variables and parameters to supply values to the delete operation.
SQL%FOUND conditional expression returns
TRUE if a row is deleted,
FALSE otherwise. See Obtaining the result status for a discussion of
SQL%FOUND and other similar expressions.
This example deletes an employee using this procedure:
You can include the
DELETE command in a
FORALL statement. A
FORALL statement allows a single
DELETE command to delete multiple rows from values supplied in one or more collections. See Using the FORALL statement for more information.