Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 7374 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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
can u give guidance abt packages of plsql
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
as a technical developer in oracle applications which type errors feced in your experience sofar
HOW TO SPOT AHIERARCHY?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what are the tools used for oracle 10g in real time.
key flexfield structure
What do you mean by Oracle MEDIA RECOVERY?
What is the use of lockboxes? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What Are Cross Validation & Adi?
