What is flashback Query ? And Use ?
Answers were Sorted based on User's Feedback
Answer / thirupathi
u are deleting some records un expectedly transaction was
commited,ucan't get back the records in this situation
using flashback query u can get back the record
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sefi
By flashback query we can get existing row from point in
time,after issue commit command..
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sanal kumar
Flashback query enables us to query our data as it existed
in a previous state. In other words, we can query our data
from a point in time before we or any other users made
permanent changes to it.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / chandra
flashback query is used for restore the data from recyclebin to database.
| Is This Answer Correct ? | 3 Yes | 3 No |
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to empty your oracle recycle bin?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain an extent?
What is bulk copy or bcp in oracle?
Explain the use of grant option in imp command.
How to use in conditions in oracle?
What is the use of Control File ?
what are the diffeenes between oracle 9i,oracle 10g
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
How to define default values for formal parameters?
Why oracle is used?