Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 6170 Views
- I also Faced
- E-Mail Answers
Answer Posted / zikku
Truncate command permanently deletes the information from a
table even after rollback we can't get that information.
Delete command temporarily deletes information from a table
after rollback we can get the information back.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between recovery and restoring of the oracle database?
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?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
3. Steps in UAT?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
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 are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is an Oracle database Full Backup?
key flexfield structure
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
default triggers available for reports
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is the sql query to find the employee who has Nth maximum salary?
What is the difference between conversions and interfaces? : oracle accounts receivable
