Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 6176 Views
- I also Faced
- E-Mail Answers
Answer Posted / mkjmkumar
Delete :
1. It is a DML
2. Speed is Slow
3. We can Use Where Clause.
4. Check Constraints Before delete.
Truncate
1. It is a DDL.
2. Speed is Fast
3. We Cant Use Where Clause
4. Delete All Rows without check of constraints.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
what is the link between suppliers and banks in ap module in oracle apps? And also query?
as a technical developer in oracle applications which type errors feced in your experience sofar
Difference between transaction type and transaction sources. : oracle accounts receivable
Could you please let me know the interfaces in OM / FA??
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the importance of batch source set up in ar? : oracle accounts receivable
What are different types of receipt reversals ? Explain them : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
What is autocashrule set? : oracle accounts receivable
A scenario for amount correction & how to use amount correction functionality in AP invoices
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.
1. What is PO rate variance gain and loss?
How many segment are present in Oracle Manufacturing
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
