Compare and contrast TRUNCATE and DELETE for a table.
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
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
can u give guidance abt packages of plsql
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What is db_recovery_file_dest in oracle? When do you need to set this value?
how to write customizations in po
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
What is the sql query to find the employee who has Nth maximum salary?
can we use lexical perameter in oracle plsql if yes how
default triggers available for reports
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is an Oracle database Partial Backup?
What is autocashrule set? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these