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 |
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
who is the father of oracle and send chodd rules
How to change program global area (pga) in oracle?
DBMS vs. RDBMS
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Is oracle an operator?
how to insert the image in table
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
How many categories of data types in oracle?
What is a Segment ?
What is coalesce function?
what is dynamic SGA and static SGA