Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 7268 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 difference between conversions and interfaces? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What is auto invoicing? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
difference of using cursor for loop and open,fetch,close.which one is better
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is db_recovery_file_dest in oracle? When do you need to set this value?
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.
Are These Dff's Flexible?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is an Oracle database Full Backup?
1. What is PO rate variance gain and loss?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
what is the link between suppliers and banks in ap module in oracle apps? And also query?
