TRUNCATE TABLE in Oracle

The TRUNCATE TABLE statement is used to remove all records from a table.
It performs the same function as a DELETE statement without a WHERE clause.

SYNTAX:
TRUNCATE TABLE [schema_name.]table_name

EXAMPLE:
TRUNCATE TABLE EMPLOYEE;


Removing rows with the TRUNCATE TABLE statement can be more efficient than dropping and re-creating a table.
Dropping and re-creating a table invalidates dependent objects of the table, requires re-granting object privileges on the table, and to re-create the indexes, integrity constraints, and triggers on the table and re-specify its storage parameters. Truncating has none of these effects.

Note: If you truncate a table, the TRUNCATE TABLE statement cannot be rolled back.