i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
Answer Posted / bipin maurya
first of all u can executed first query after that u can executed sec query
ALTER TABLE table2 ENABLE ROW movement
flashback TABLE table2 TO timestamp systimestamp-interval
'100' minute
Thanks
Bipin Maurya
Mo-+919812630225
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is bulk copy or bcp in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain the use of owner option in exp command.
What is a data dictionary and how can it be created?
How to sort output in descending order in oracle?
Can group functions be mixed with non-group selection fields?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Where do you use decode and case statements?
How to delete a user account in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
Why do we need oracle client?
Design database draw er diagram for a certain scenario ?
What is the difference between alert log file and tarce file ?
How many anonymous blocks can be defined?
How to create tables for odbc connection testing?