Truncate command is very useful in oracle unlike other commands it has to
be used with a lot of care because once issued we cannot rollback the results.
Once a truncate command is issued the changes are made permanent in the database.

Truncate command can be issued on two types of oracle objects TABLE and CLUSTERS.

Truncate TABLE my_tbl ;
Truncate CLUSTER my_tbl_cluster ;


We have to specify the type of object that truncate has to operate on.


Oracle will not fire any Delete triggers once we issue a truncate command.


The fundmental difference between a delete command and a truncate command is
that we can issue a rollback after a delete statement.
While a rollback statement after a Truncate will have no effect.