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 |
Difference between negative and positive adjustments : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
what are the API of GL,PO,AP
What Are Cross Validation & Adi?
Name a tablespace automatically created when you create a database.
How can you gather statistics on a table?
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
3. Steps in UAT?
why r u using etl tool.
How do you create a credit note against an invoice? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,