what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / vasanth
Truncate
1.Truncate Can be DDL Command.
2.it can be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is semphore explian it?
8. Supporting AP, AR and GL?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
can u give guidance abt packages of plsql
what are the API of GL,PO,AP
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Difference between transaction type and transaction sources. : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation