oracleÓαê

SET NEWPAGE NONE HEADING OFF SPACE 0 PAGESIZE 0 TRIMOUT ON TRIMSPOOL ON LINESIZE 2500 colsep | feedback off termout off pages 0
set colsep |
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
set feedback on
declare cursor cur_no is
select  beginno,endno  from hm where 1=1;
beginno varchar2(11);
endno varchar2(11);
begin
  for my_no in cur_no loop
    beginno:=my_no.beginno;
    endno:=my_no.endno;
    while (beginno<=endno) loop
    insert into hmnew values(beginno);
    commit;
    beginno:=beginno+1;
    end loop;
    commit;
  end loop;
end;