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


Please Help Members By Posting Answers For Below Questions

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

754


How would you determine what sessions are connected and what resources they are waiting for?

1612


8. Supporting AP, AR and GL?

1811


What is the difference between recovery and restoring of the oracle database?

659


Give two methods you could use to determine what DDL changes have been made.

6019






1. What is PO rate variance gain and loss?

2312


What is the importance of batch source set up in ar? : oracle accounts receivable

712


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1610


can u give guidance abt packages of plsql

1644


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

668


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1704


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.

1867


difference of using cursor for loop and open,fetch,close.which one is better

1250


What view would you use to determine free space in a tablespace?

1775


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1902