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 |
What is the use of lockboxes? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
What is an Oracle database Partial Backup?
Give the two types of tables involved in producing a star schema and the type of data they hold.
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the Symbol use for Inner Join
what is the difference between oracle 81,91,11i
How would you determine the time zone under which a database was operating?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
What is the difference between the SQL*Loader and IMPORT utilities?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Give the stages of instance startup to a usable state where normal users may access it.