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 materialized view in Oracle?
what is foreign key?
How to drop an index in oracle?
How oracle handles dead locks?
Is there any function in oracle similar like group_concat of mysql?
Explain alias?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What are the uses of synonyms?
Can a parameter be passed to a cursor?
What is MTTR advisor in Oracle?
How to convert characters to times in oracle?
What is an oracle recycle bin?