SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find if update changed something or not

Igor S.Jan 31 2013 — edited Feb 1 2013

Hi folks,

If you have a procedure that takes 10 parameters and updates a table. How would you check if something was really updated? The only way I know how to do this is to query the table and then compare input parameters with the query to see if anything changed. If someone updates data and changes it compared to previous state I need to return 1 or 0 if update did not change anything.

Is there any other way of finding this information?

Best regards,
Igor

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2013

Added on Jan 31 2013

7 comments

3,504 views