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 you store pictures in a database?
Explain the family trees and connection by clause
What are the Limitations of a CHECK Constraint ?
Explain what are synonyms used for?
What is execute immediate in oracle?
How to retrieve the count of updated rows?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
What is the purpose of a cluster?
Compare and contrast between sql and sql server and explain its various functions?
what is the difference between sql& oracle?
Shall I get Pro*C Compiler in Oracle-10g release ?