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 |
What is a cursor and what are the steps need to be taken?
How to write date and time literals in oracle?
Explain the types of exception?
difference between truncate and delete ,drop?
can u plz provide me oca sql dumps please i need them
what is insert all statement in sql
What are the arithmetic operations?
can we pass two out parameters at a time in function?please answer to my question
What is connection pool in oracle?
Is oracle a relational database?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
What is PL/SQL ?