Truncate command in oracle is DDL command or DML command ? give the answer with descirptive reason which is and why?

Questions by nareshgupta12   answers by nareshgupta12

Showing Answers 1 - 17 of 17 Answers

Praveen reddy.P

  • Jan 31st, 2007

Truncate is a DDL statement

  Was this answer useful?  Yes


  • Feb 17th, 2007

Truncate is a DDL Statement.Whereas Delete is a DML Statement.

  Was this answer useful?  Yes


  • Feb 17th, 2007

Truncate is a DDLcommand.Whereas Delete is a DML Command.

  Was this answer useful?  Yes


  • Feb 25th, 2007

truncate is DDL command . truncate means delete+commit.
DDL commands are directly connecting to database.
DML commands are  first connecting to memory cache.
these are deferences between ddl and dml

  Was this answer useful?  Yes


  • Sep 14th, 2007

Truncate command is a DDL statement.
DDL ststements can't be rollback. Truncate statement can't be rollback.
In DDL statement we can't use WHERE. In truncate also we can't use WHERE.

DELETE is a DML statement we can rollback as well as we can use WHERE.

  Was this answer useful?  Yes


  • Aug 27th, 2009

Following are different types of SQL language
DQL - Data query language e.g. select
DDL - Data definition language e.g. create, alter, drop
DML - Data manipulation language e.g. insert, update, delete
TCL - Transaction control language e.g commit, rollback, savepoint
DCL - Data control language e.g grant, revoke

  Was this answer useful?  Yes


  • Jun 9th, 2012

Truncate is a DDL command. Internally what it does is it drops the whole table and recreate the structure.

  Was this answer useful?  Yes


  • Jul 13th, 2012

TRUNCATE is a data definition language (DDL) command.Removes all rows from the table,leaving the table empty and the table structure intact.

  Was this answer useful?  Yes

Krishna G

  • Mar 4th, 2013

Truncate is a DDL command.You can not rollback the data once you done truncate command

  Was this answer useful?  Yes

vishnu vardhan

  • Nov 16th, 2014

TRUNCATE is a DDL command.If u want to delete all the records permanently from the table truncate command will be use.

  Was this answer useful?  Yes


  • Dec 8th, 2014

If we compare truncate command with windows it is just link s=Shift+Del which deletes permanently.

  Was this answer useful?  Yes


  • Dec 9th, 2014

since ddl deals with the structure of objects n here truncate is also used for permanently deleting the data with objects so truncate is a ddl command..

  Was this answer useful?  Yes


  • Nov 14th, 2015

Truncate is DDL command, not a DML command
When we issue Truncate on a database table, the records are deleted from the table, and structure remains same. Once we issue truncate on a table, the records will not restored again.
Truncate is a DDL command, and all DDL command by default auto committed. i.e once we apply DDL commands we cannot apply commit or rollback on it. That is the reason Truncate is DDL command.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions