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




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA