Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 7526 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
How would you go about increasing the buffer cache hit ratio?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
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?
How do you create a credit note against an invoice? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
what is difference between inner join & nested query or subqueries
What is the difference between oracle media recovery and crash recovery?
What is the disk migration? what is the steps involved in oracle disk migration?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
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 the use of transaction flexfield in autoinvoice? : oracle accounts receivable
which one is currently in used software cmpanies.
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
