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 |
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
What is a system tablespace?
how many types of index?
What is meant by redo log buffer ?
what is the uses of cusor
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What are the different approaches used by Optimizer in choosing an execution plan ?
Give the constructs of a package, function or a procedure.
What is mean by Program Global Area (PGA) ?
What is materialized view in Oracle?
Explain what are synonyms used for?