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 - 16 of 16 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

Give your answer:

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

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions