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!

Help with a trigger

2641697Jun 23 2014 — edited Jun 23 2014

Hi,

I have a master table and a detail table with a relationship and I want storage the row totals of the detail table into the master table. I want use a trigger to do that, but I don't want use a trigger row by row. I want to fire the trigger after the sql statment has been executed but I need to now the foreign key in the detail table to execute a count statement and update the correct row in the master page. Do you have idea how do that ? . Do you now some documentation or similar example  with my problem ?

Best regards

German G

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2014
Added on Jun 23 2014
4 comments
1,808 views