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 do you understand by a database object?
what is view?
What is Database Link ?
What is the order of defining local variables and sub procedures/functions?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
Can a formula column referred to columns in higher group ?
what is the syntax of update command?
What are the different windows events activated at runtime ?
select statement does not retrieve any records. what exception is raised?
What is a deadlock ? Explain .