有选择和处理的进行数据转移的测试过程

--创建测试表1
create table demo1 (
noteid varchar2(34),
str varchar2(10),
birth date
)
--创建测试表2
create table demo2 (
noteid varchar2(34),
str varchar2(10),
birth date
)

select * from demo2
--插入测试数据
insert into demo1 values('2800320100000120091203104700000001','test1',sysdate);
insert into demo1 values('2800320100000120091203104700000002','test2',sysdate);
insert into demo1 values('2800320100000120091203104700000003','test3',sysdate);

declare
p_id varchar2(34);
begin
for c in (select * from demo1)
loop

--生成主键 调用过程的
sic_varchar34_serialnumber2('28003201000001','demo2','noteid',p_id);
--
insert into demo2(noteid,str,birth)
values(p_id,c.str,c.birth);
commit;
dbms_output.put_line(p_id||'c.str='||c.str);
end loop;
end;

完成后的过程：

create or replace procedure batch_insert
is p_id varchar2(34);
begin
  for c in (select * from demo1) loop
 
    --主键
    sic_varchar34_serialnumber2('28003201000001', 'demo2', 'noteid', p_id);
    --
    insert into demo2 (noteid, str, birth) values (p_id, c.str, c.birth);
    commit;
    dbms_output.put_line(p_id || 'c.str=' || c.str);
  end loop;

end batch_insert;

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9700459/viewspace-621161/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9700459/viewspace-621161/