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.

Home »
Oracle »
Table » 

Table Creation:
  1. Creating a Table
  2. Getting Information on Tables
  3. Information on Columns in Tables
  4. Renaming a Table
  5. Truncating a Table
  6. Dropping a Table