SQL & PL/SQL

Hi Team,

I am looking for the best and easiest way to implement the below logic using PL SQL procedure

QuestIon:-

I have a table which contains some info( name, id,desc,from_date,last_date) and I would like to write a procedure , when I run  the procedure it should check this table records and do the following:

1) If there is any new entry

  then It should be added to Table_1(id,group,date).

  AND

  Also ,new record should be inserted into Table_2('XYZ',date,id,'XWQ')

2) If there is any change in existing record fields ( from_date & last_date )

        then it should check Table_1 table for that particular record and if it doesn't exists , it should insert a new record and if not , it should ignore it.

       AND

       Also ,new record should be inserted into Table_2('0',date,id,'xxx',date,date)

Please let me know if you need any more info.

I would appreciate your help ! Thank You All !