Delete rows from a table according to specified criteria.
DELETE FROM table_spec
[WHERE < predicate-list | CURRENT >
[ < ON / OF > [ CURSOR ] cursor
[ WITH options ]
Required. table is the name of the table in the database that contains the rows to be deleted.
Optional. Caution! If omitted, ALL rows will be deleted from the specified table. predicate-list - Criteria to determine which rows will be deleted. CURRENT - Delete only the current row.
Optional. The cursor on which to perform the delete. If omitted, the delete will be performed on the current cursor.
Optional - Specify options to be used for this command.
> DELETE FROM CUSTOMERS WHERE CUSTOMER_NO = 1240