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!

Updating count data based on records in another table

972653Nov 6 2013 — edited Nov 6 2013

I have 2 tables

Table 1
Name Item   Date
Jon  Apples  06/11/2013 00:30:00 hrs
Sam  Oranges
Nish Apples

Table 2 - Net count
Name Item Count
Nish Apples 10
Nish Oranges 17
Nish Banana
Sam Apples 10
Sam Oranges 1
Sam Bananas 1
Jon  Apples 8

I need to create a job that checks Table 1 for new records added after last run and then add the count in Table 2 accordingly.
Please guide how to achieve this using PL/SQl or something similar

This post has been answered by TPD-Opitz on Nov 6 2013
Jump to Answer

Post Details

Locked on Dec 4 2013
Added on Nov 6 2013
2 comments
1,536 views