CURSOR c_fgsr IS
    SELECT DISTINCT SUM(b.qty/1000) inv_qty, 
           a.division division, a.sopcust sopcust, a.program program,
           a.sopgrp sopgrp, a.sopclothtype sopclothtype,
           a.color_group color_group, a.sized sized, a.sopmfgtype sopmfgtype,
           a.product_type product_type, b.scheddate,
           DECODE(COUNT(a.skutype),1,a.skutype,'****') skutype,
           DECODE(a.sopmfgtype,'MAKE','NA','SOURCED') mfgloc
      FROM springs.si_sop_fgitem a,
           springs.si_sop_fgsr b
     WHERE a.item = b.item
     GROUP BY b.item, a.division, a.sopcust, a.program, a.sopgrp,
           a.sopclothtype, a.color_group, a.sized, a.sopmfgtype,
           a.product_type, b.scheddate, skutype

FOR v_sr IN c_fgsr
    LOOP
      INSERT INTO springs.si_sop_aggr_fgsr
             (sbu, customer, program, sopgrp, cloth_type, 
              fin_type, fin_size, mfg_type, prod_type, 
              fg_type, mfg_loc, Mfg_fac)
      VALUES (v_sr.division, v_sr.sopcust, v_sr.program, 
              v_sr.sopgrp, v_sr.sopclothtype,  v_sr.color_group,
              v_sr.sized, v_sr.sopmfgtype, v_sr.product_type,
              v_sr.skutype, v_sr.mfgloc, NULL);
       
     n_ins_inv_cnt := n_ins_inv_cnt + 1;
       
  END LOOP;

UPDATE springs.si_sop_aggr_fgsales
     SET mfg_fac =
           (SELECT DISTINCT  a.si_prim_vendor 
               FROM springs.si_sop_fgitem a,
                    stsc.loc b
            WHERE a.loc = b.si_prim_vendor

 update tab
 set col = (select 1 from dual;)
 
 update tab 
 set col = (select 1,2,3 from dual);

UPDATE tab a
   SET a.col = (SELECT col
                FROM tab1 b
               WHERE b.col1 = a.col1)

UPDATE tab a
   SET a.col = (SELECT col
                FROM tab1 b
               WHERE b.col1 = a.col1)

for record in cursor loop  update table    set column - record.value  where key = record.key;end loop;

Table 1

col1 col2
---- ----
A    NULL
B    NULL
C    NULL

Table 2

cola colb
---- ----
A    1
A    2
A    3