To erase existing records in a table, use the DELETE statement.
In an Oracle database, there is no difference between delete and delete from; yet, writing code like this is typical. [WHERE condition] DELETE FROM table This conforms to the SQL-92 standard.
To eliminate all records, the SQL Truncate statement locks the table and page. The Delete command creates a record in the transaction log for each removed row. The truncate command does not add entries to the transaction log for each removed row. The Delete command is more time consuming than the Truncate command.