We can use FOR UPDATE cursors in select statement for auditing purpose:
E.g: select * from per_all_people_f for update;
Here in this case..a employee details has been changed and the updation will be done by a scheduled concurrent program. So we can check the colums which are in wait for updation form this query
Check the below link for more info...
http://www.java2s.com/Tutorial/Oracle/0500__Cursor/UsingWHERECURRENTOF.htm
E.g: select * from per_all_people_f for update;
Here in this case..a employee details has been changed and the updation will be done by a scheduled concurrent program. So we can check the colums which are in wait for updation form this query
Check the below link for more info...
http://www.java2s.com/Tutorial/Oracle/0500__Cursor/UsingWHERECURRENTOF.htm
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.