▪The searched DELETE statement, DELETE FROM table_name [WHEREsearch_condition], deletes all rows in a given table or the rows specified with search_condition.
▪The positioned DELETE statement, DELETE FROM table_name WHERE CURRENT OF cursor_name, deletes the current row of the cursor.
table_name can be a table name or an alias.
Tip: If you want to delete all rows in a table, consider using the TRUNCATE statement.