Delete Statement
This statement deletes rows from a database table.
This statement has the following syntax:
• Non-cursor version:
[repeated] delete from tablename [corrname]
[where searchcondition];
• Cursor version:
delete from tablename where current of cursor_variable;
The non-cursor version of the delete statement deletes selected rows from a table. The cursor version deletes one row at a time.