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 |
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
What is bulk collect in oracle?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What are the various constraints used in oracle?
What are the benefits of ordbms?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
what is the difference between substr and instr function in oracle?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Is there a combination of "like" and "in" in sql?
What do you mean by merge in oracle?
What is execute immediate in oracle?
How to use "while" statements in oracle?