Can we get the deleted Record again if the delete
transaction has been committed.
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is chargeback invoice? How do we create it? : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
How to clone the database using RMAN back
1. What is PO rate variance gain and loss?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What are different types of transactions in ar? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
Give two methods you could use to determine what DDL changes have been made.
How do you create a credit note against an invoice? : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Explain how to close periods in ar. : oracle accounts receivable