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 |
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
1. What is PO rate variance gain and loss?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
which one is currently in used software cmpanies.
How would you determine the time zone under which a database was operating?
Explain the use of table functions.
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?