测试数据的添加

 CREATE OR REPLACE procedure pr_test

as
i number;
v_comm varchar2(1000);
begin

  for  i in 1..1000 loop
     insert into WH_WAGES_ITEM(COMP_CD,CENTER_CD,COST_CD,COST_SEQ,COST_CLASS,COST_NM,COST_UNIT,COST_RATE,PRE_COST,
    RAISE_COST,FR_TIME,TO_TIME,APPLY_DT,END_DT,INP_USR,INP_DT,UPD_USR,UPD_DT)
    VALUES ( i || '',i || '','00',i || '','aa',i || '',i || '',i || '',i || '',i || '',i || '',i || '',i || '',i || '',i || '',sysdate,i || '',sysdate);
   end loop;

EXCEPTION
   /* 기타오류 DEFINE */
   WHEN OTHERS
   THEN
       v_comm := '-10101 : KEY CREATE ERROR'||SQLERRM;
   RETURN ;
end pr_test;
/