Interested to Buy Any Domain ? << Click Here >> for more details...
Can we get the deleted Record again if the delete
transaction has been committed.
- 4 Answers
- 6778 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 ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
what are basic modules required to implement oracle application in any oraganisation?
What does coalescing a tablespace do?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
the user should know to which database he is connected currently in oracle
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
how to replace not in with not exist?
Explain about party and customer in ar : oracle accounts receivable
what is correlated subquery
What are different types of receipt reversals ? Explain them : oracle accounts receivable
Oracle General 
