Can we get the deleted Record again if the delete
transaction has been committed.
- 4 Answers
- 5196 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 |
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
Explain about party and customer in ar : oracle accounts receivable
Explain the difference between a hot backup and a cold backup and the benefits associated with each
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
what is diff between pre insert,on insert,post insert triggers?
Where would you look for errors from the database engine?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
How do you add a data file to a tablespace?
how to create an user in oracle 10g.please give me an example..
What is the disk migration? what is the steps involved in oracle disk migration?
Oracle General 
