How can I verify the latest data from above table?

I have a table with two columns name namely current,history but I dont have time stamp to make sure that when the data is updated or deleted.
Now How can I verify the latest data from above table?

Questions by govkj   answers by govkj

Showing Answers 1 - 2 of 2 Answers

fazal

  • Oct 29th, 2013
 

Select max (ora_scan) from table;
Select scn_to_timestamp (the_above_output) from dual;

kamesh

  • Jan 30th, 2018
 

Based on the surrogate key we have identified the data Because surrogate keys is unique identifer for each row in a table

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions