To remove all rows (full data) from a table, use the truncate SQL query. It's similar to a DELETE statement that doesn't have a WHERE clause.
The DELETE TABLE command is slower and requires more resources than the TRUNCATE TABLE command.
The Drop table command can be used to delete a whole table, but it also deletes the table structure. TRUNCATE TABLE does not remove the table's structure.
Notes: After the truncate table statement, the rollback process is not available. You can't use a flashback table statement to get the contents of a table once it's been truncated.
Next