Truncating a Table

You truncate a table using the TRUNCATE statement. This removes all the rows from a table and resets the storage area for a table.

SQL> TRUNCATE TABLE new_employee;

Table truncated.

SQL>