Can we get the deleted Record again if the delete
transaction has been committed.
Answers were Sorted based on User's Feedback
Answer / kd
Using flashback query
select * from t1 as of scn 1234567;
Using flashback transaction query to get undo sql.
Using flashback table to scn/timestamp
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / david
@SWATI....
may i know how will u get this ...explanation plzzzz....
gunjan david.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / swati
Yes we can get the deleted Record again if the delete
transaction has been committed. Since delete is a DML
command, so it can be triggered back, as well as Rolled
back also.
Is This Answer Correct ? | 1 Yes | 5 No |
How do you resize a data file?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What type of index should you use on a fact table?
What command would you use to create a backup control file?
Explain about party and customer in ar : oracle accounts receivable
Explain the difference between a data block, an extent and a segment.
can we use lexical perameter in oracle plsql if yes how
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what is the difference b/w oracle8i and oracle9i
Give the reasoning behind using an index.
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
Explain the use of setting GLOBAL_NAMES equal to TRUE.