Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle Truncate Table Statement

The Oracle TRUNCATE TABLE statement is used to remove all records from database table but keeps the structure of the table. The truncate table statement is similar to delete statement without a WHERE clause.

Oracle TRUNCATE TABLE Syntax

To remove all records from existing table, use the following syntax:

Syntax

TRUNCATE TABLE tablename;

Parameters:

tablename: The table name from which you want to remove all records.

Oracle TRUNCATE TABLE example

The following Oracle statement to remove the content of the table:

Example

TRUNCATE TABLE tblCustomer;

Note:

In the above example, we have deleted the record for customer "Sunil Shetty".