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