3 Replies Latest reply: Nov 7, 2013 10:22 AM by rp0428 RSS

    Updating count data based on records in another table

    972653

      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 Java JDBC API