Skip to Main Content

Oracle Database Discussions

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!

What Oracle Database Feature to use

802562Oct 26 2010 — edited Oct 26 2010
What Oracle Database Feature to use to make automatic update of table based on child tables insert or update

For example


Table Invoice
1. Invoice No
2. Invoice Date
3. Desc
4. Total Price <-------------------------------|
|
|
Table Item_Sold |
1. Item sold ID |
2. Item selling price <---------------------------| sum of all records whith invoice no = to the parent table.
3. Inventory ID (FK to Inventory table)
4. Invoice no (FK to Invoice table)


The Invoice has one to many relationship with Item_sold, and the Total Price should be sum of Item selling price.

Any trigger a like or other cool Oracle features that can address this design?



Thank you.

Regards,
Sinardy

Comments

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

Post Details

Locked on Nov 23 2010
Added on Oct 26 2010
7 comments
158 views