Delete Statement
This statement deletes rows from a database table.
It has the following syntax:
Non-cursor version:
[repeated] delete from tablename [corrname]
[where searchcondition];
Cursor version:
delete from tablename where current of cursor_variable;