Javatpoint Logo
Javatpoint Logo

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

ORACLE TRUNCATE TABLE statement

Table truncated

ORACLE TRUNCATE TABLE statement

Table after truncate

ORACLE TRUNCATE TABLE statement
Next TopicWHERE




Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA