Can we get the deleted Record again if the delete
transaction has been committed.
Answers were Sorted based on User's Feedback
Answer / kd
Using flashback query
select * from t1 as of scn 1234567;
Using flashback transaction query to get undo sql.
Using flashback table to scn/timestamp
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / david
@SWATI....
may i know how will u get this ...explanation plzzzz....
gunjan david.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / swati
Yes we can get the deleted Record again if the delete
transaction has been committed. Since delete is a DML
command, so it can be triggered back, as well as Rolled
back also.
| Is This Answer Correct ? | 1 Yes | 5 No |
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is Tax Categories?
What is the importance of batch source set up in ar? : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
what are the advantages of Oracle over other databases..? please give me reply...
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
Name three advisory statistics you can collect.
What is an Oracle database Full Backup?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the disk migration? what is the steps involved in oracle disk migration?