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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,760 views