What is Difference Between delete and Truncate?

Answers were Sorted based on User's Feedback



What is Difference Between delete and Truncate?..

Answer / muralipitti

Delete - temparaly delete the table we can undo it using
rollback where as

truncate= delete+commit we can't rollback it .

Is This Answer Correct ?    4 Yes 0 No

What is Difference Between delete and Truncate?..

Answer / udhayakumar

delete is used to delete one or more rows from the table
where as truncate to delete all the rows without its
structure from the table

Is This Answer Correct ?    2 Yes 0 No

What is Difference Between delete and Truncate?..

Answer / nandini sett

Both delete and Trunate are DML or Data Manupilating
Language.
Both statements --- Delete table_name and Truncate table
table_name --- deletes all rows.
Truncate Table works faster than delete.
Truncate table does not support where clause and truncate
doe not fire a trigger. When truncate is used the deleted
rows are not entered in transaction log.

Is This Answer Correct ?    2 Yes 1 No

What is Difference Between delete and Truncate?..

Answer / rajesh

Delete is DML statement which can delete data from table
which needs to be commited afterwards. But it doesn't free
memory area occupied by the data in the table.Where clause
can be used.

Truncate is DDL statement which is auto commit. It not only
deletes all data from table, but it also frees the memory
area occupied the data in the table. where clause is not
permitted. Works faster than delete statement

Is This Answer Correct ?    1 Yes 0 No

What is Difference Between delete and Truncate?..

Answer / shivaindu

Differentiate between TRUNCATE and DELETE:
-----------------------------------------
TRUNCATE deletes much faster than DELETE
TRUNCATE HAS NO CONDITION CLAUSE. WHERE AS DELETE HAS CONDITION.

Delete
~~~~~~
1> Executes triggers
2> DML statement
3> Roll back possible
4> Flash query can get the data
5> cannot free the table free space

Truncate
~~~~~~~~
1>No trigger Execution
2>DDL statement
3>No roll back possible
4>can’t get data from flash queries
5>Option to free table space

Is This Answer Correct ?    1 Yes 0 No

What is Difference Between delete and Truncate?..

Answer / chandrakala

also delete is a DML statement where as truncate is a DDL
statement.

Is This Answer Correct ?    2 Yes 2 No

What is Difference Between delete and Truncate?..

Answer / shankar

DELETE and TRUNCATE both delete table from database, but

DELETE - temperorily deletes the table so we can undo the
table.

TRUNCATE - Perminently delete the table from database so we
cant undo it.

Is This Answer Correct ?    4 Yes 7 No

What is Difference Between delete and Truncate?..

Answer / kiran.

Delete(DML) : All records not possible to Delete at a time,
Where clause is allowed.
structure of the table is available.
Roll Back is possible.

Truncate(DDL): All records possible to Delete at a time,
Where clause is not allowed.
structure of the table is not available.
Roll Back is possible.
>Truncate Table<tablename>;

Is This Answer Correct ?    0 Yes 3 No

What is Difference Between delete and Truncate?..

Answer / joe

Delete is DML and truncate is DDl;
both or used to delete the records from the table.

We can rollback the deleted records but we cant when we used truncate.

Delete is faster than truncate

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More SQL PLSQL Interview Questions

Can you call pl/sql package functions from within a fast formula?

0 Answers  


In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,


how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,


What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,


What are the data types allowed in a table?

3 Answers  






How many types of literals are available in pl sql?

0 Answers  


Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  


What is basic structure of pl sql?

0 Answers  


Why do we use procedures?

0 Answers  


How do I find sql profiler?

0 Answers  


What is assignment operator in pl sql?

0 Answers  


What are types of indexes in sql?

0 Answers  


Categories