Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 6172 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
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
How to clone the database using RMAN back
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 the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the importance of batch source set up in ar? : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
how to replace not in with not exist?
What do you mean by Oracle MEDIA RECOVERY?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Explain the use of table functions.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
