what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58289 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / mkjmkumar
TRUNCATE
1. It is DDL.
2. Speed is faster
3. Do not Check Constraints.
4. Roll Back is not possible.
5. Can not use where clause
DELETE
1. It is not a DDL
2. Speed is slow
3. Check constraints, If Exists then shoe error.
4. We can rollback .
5. User Where Clause
| Is This Answer Correct ? | 78 Yes | 8 No |
Post New Answer View All Answers
Explain the payment term in ar. : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
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
Are These Dff's Flexible?
What is Tax Categories?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Explain the use of table functions.
how to write customizations in po
How do you create a credit note against an invoice? : oracle accounts receivable
How to clone the database using RMAN back
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Differentiate between transaction type and transaction source? : oracle accounts receivable
Can we modify approve purchase order?if yes what is navigation?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is mrc and what is its use? : oracle accounts receivable
