what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / vijay rana
1.truncate is a DML command but Delete is a DDL Command
2.truncate is much faster then Delete
3.we can rollback delete but we cant rollback Truncate
4.we can not use where in truncate but we can use where with
delete
5.in case of truncate memory released immediately, but in
case of delete memory dosen release if we dont press commit.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Difference between transaction type and transaction sources. : oracle accounts receivable
What is Tax Categories?
What is auto invoicing? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
how to replace not in with not exist?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
what are the tools used for oracle 10g in real time.
What is an Oracle database Full Backup?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
How many segment are present in Oracle Manufacturing
as a technical developer in oracle applications which type errors feced in your experience sofar
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable