Interested to Buy Any Domain ? << Click Here >> for more details...
What is flashback Query ? And Use ?
- 4 Answers
- 9188 Views
- Thermotech, I also Faced
- E-Mail Answers
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 |
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What are the various types of snapshots ?
How view is different from a table?
How to use "if" statements on multiple conditions?
How to get a list of all user accounts in the database?
What is the use of aggregate functions in oracle?
does the query needs a hint to access a materialized view?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
What is different bet native dynamic sql and Dbms_Sql?
Oracle General 
