Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 7445 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 importance of batch source set up in ar? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Difference between transaction type and transaction sources. : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain prerequisites and post activities of oracle database installation
What is supporting issues GL AP and AR?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
What is an Oracle database Partial Backup?
What Are Cross Validation & Adi?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
