Skip to Main Content

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!

Scan Table for Value Change(s)

Jeremy McNallyJul 20 2015 — edited Jul 22 2015

Table A has the values below for example: As soon as a change takes place in the PARAM_VALUE column (for the PARAM_NAME called "LINE")... I need to be able to know right away and perform my logic on that change.

Multiple changes can take place at the same time and I need to account for that.

I am not sure how to do make this work since there could be multiple changes on the same name/value pair for different order numbers at the same exact time.

SampleData6.PNG

I was originally thinking that a trigger would work to where as soon as a value changes for the given param_name, perform my logic.

Could you guys please give me some detailed help on this with examples. I would appreciate it very much. Thank you in advance.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 19 2015
Added on Jul 20 2015
4 comments
650 views