3 Replies Latest reply on Nov 7, 2013 4:22 PM by rp0428

    Updating count data based on records in another table


      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