Can we get the deleted Record again if the delete
transaction has been committed.
Answer Posted / krishh
Yup can get it using 'FLASHBACK QUERY'.....
SYNTAX:
Flashback Table <tablename>
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is an Oracle database Full Backup?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is supporting issues GL AP and AR?
8. Supporting AP, AR and GL?
Why more redos are generated when the oracle database is in begin backup mode?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
What is db_recovery_file_dest in oracle? When do you need to set this value?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?