76

ORACLE TRUNCATE TABLE statement

In Oracle, the truncate statement is used to remove all the records of a table. It works same as the delete statement but without using where clause.

Syntax

Example 1

Table before truncate

Table truncated

Table after truncate