-- Created on 2006-1-9 by ADMINISTRATOR

declare

-- Local variables here

v_unitnum   varchar2(14);

v_unitname  varchar2(64);

v_Parentnum varchar2(14);

CURSOR c_routenum is

select t.routenum, t.routename, t.beloteamnum

from g_routenum t;

begin

-- Test statements here

open c_routenum;

fetch c_routenum

into v_unitnum, v_unitname, v_Parentnum;

while c_routenum%found loop

insert into g_unitnum

(unitnum,

unitname,

respemplnum,

symbol,

mainttypenum,

querytype,

parentnum)

values

(v_unitnum, v_unitname, '', '6', '', '', v_Parentnum);

/*dbms_output.put_line(v_unitname);*/

fetch c_routenum

into v_unitnum, v_unitname, v_Parentnum;

end loop;

close c_routenum;

commit;

end;

posted on 2006-01-10 13:01 Java Fly 阅读(624) 评论(0)  编辑  收藏 所属分类: Oracle PL/SQL