conn hajo/hajo

   col chg_01   for a10
   col chg_02   for a10
   col group_01 for a10
   col group_02 for a10
   select ref_01, group_01 from hajo.hajo_table01 order by 1;
   select ref_02, group_02 from hajo.hajo_table02 order by 1;


      MERGE  INTO hajo.hajo_table02 b
            USING hajo.hajo_table01 a
               ON (a.ref_01 = b.ref_02)
         WHEN NOT MATCHED
            THEN
               INSERT VALUES (
                  a.ref_01,
                  a.number_01,
                  a.status_01,
                  a.group_01,
                  a.assignee_01 )
      WHEN MATCHED
         THEN
            UPDATE SET
               b.number_02     = a.number_01,
               b.status_02     = a.status_01,
               b.group_02      = a.group_01,
               b.assignee_02   = a.assignee_01
      ;


   select ref_01, group_01 from hajo.hajo_table01 order by 1;
   select ref_02, group_02 from hajo.hajo_table02 order by 1;

   -- commit;
   rollback;

   quit