Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65430 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / rams
TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.
DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.
| Is This Answer Correct ? | 13 Yes | 21 No |
Post New Answer View All Answers
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 do you mean by Oracle MEDIA RECOVERY?
How would you go about increasing the buffer cache hit ratio?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
which one is currently in used software cmpanies.
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
What is the difference between conversions and interfaces? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
can u give guidance abt packages of plsql
What Are Cross Validation & Adi?
Explain how to close periods in ar. : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the importance of batch source set up in ar? : oracle accounts receivable
