Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 7425 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
How would you determine who has added a row to a table?
What is an Oracle database Partial Backup?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is the difference between conversions and interfaces? : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
What is an Oracle database Full Backup?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What are different types of transactions in ar? : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How do you create a credit note against an invoice? : oracle accounts receivable
