Interested to Buy Any Domain ? << Click Here >> for more details...
Can we get the deleted Record again if the delete
transaction has been committed.
- 4 Answers
- 6710 Views
- I also Faced
- E-Mail Answers
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 do you mean by hz_ in customer tables? : oracle accounts receivable
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
Give the stages of instance startup to a usable state where normal users may access it.
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Give the two types of tables involved in producing a star schema and the type of data they hold.
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?
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Explain the process of recievables in oracle financials. : oracle accounts receivable
Oracle General 
