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

snippet
Truncate table table_name;

Example 1

Table before truncate

ORACLE TRUNCATE TABLE statement

Table truncated

ORACLE TRUNCATE TABLE statement

Table after truncate

ORACLE TRUNCATE TABLE statement
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +