Interested to Buy Any Domain ? << Click Here >> for more details...
wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
- 3 Answers
- 8300 Views
- Apollo, I also Faced
- E-Mail Answers
Answer Posted / rakesh
The Main Difference Between DELETE & TRUNCATE Are :-
[1] DELETE - is a DML Command & TRUNCATE - is a DDL Command
[2] After DELETE - can rollback the Records & After TRUNATE
- cannot rollback the records
[3] In DELETE Command you can give the conditions in WHERE
Clause & In TRUNCATE you cannot give conditions
[4] After using DELETE Command The memory will be occupied
till the user does not give ROLLBACK or COMMIT & After using
TRUNCATE Command The memory realeased immediately
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is pl sql commands?
How to check if a column is nullable before setting to nullable?
What does stand for in sql?
Does truncate table reset auto increment?
What is on delete set null?
What is the need of a partition key?
How to run sql statements with oracle sql developer?
What is auto increment in sql?
Can we alter stored procedure?
What is the difference between clustered and non-clustered indexes?
What does the argument [or replace] do?
Which join is like inner join?
In pl/sql, what is bulk binding, and when/how would it help performance?
How do I remove duplicates in two columns?
What are the advantages of sql? Explain
