循环表记录，改变某列再插入表
DECLARE nNumber    int;


BEGIN 
 
  nNumber :=1;
  LOOP
    EXIT WHEN nNumber = 5;
   
    INSERT INTO t_pick_detail (order_number,line_number,type,uom,work_q_id,work_type,status,item_number,planned_quantity,picked_quantity
    ,staged_quantity,pick_location,picking_flow,load_id,pick_area,wh_id,create_date)
    SELECT order_number,line_number,type,uom,work_q_id,work_type,status,item_number,planned_quantity,picked_quantity
    ,staged_quantity,pick_location,picking_flow,load_id,pick_area,'Whouse' || TO_CHAR(nNumber),SYSDATE
    FROM t_pick_detail;
    Commit;
    nNumber := nNumber + 1;
   
    END LOOP;
end;