Can we get the deleted Record again if the delete
transaction has been committed.
- 4 Answers
- 5204 Views
- I also Faced
- E-Mail Answers
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 |
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
What is store procedure?and how do u take the values from database and run in scripts?
where the dff data will be stored
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is db_recovery_file_dest in oracle? When do you need to set this value?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
How to find locks exists in a table or not?
What is the use of lockboxes? : 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,
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Oracle General 
