declare
mynum number(5);
begin
mynum := 40001;
loop
insert into cs (wzh,dygd,sbgxxh,sbgxlb,zyjz,jcsz,jcrq,jcyqbh,bjnd,gywd,gyyl,wd,sd,fs,jcry)
values (mynum,'气分','','阀门','粗丙烯','10','2004/4/13','102446651','1','62.4','2.1','27','50','0.1','严龙');
exit when mynum = 40061;
mynum := mynum + 1;
end loop;
end;
mynum number(5);
begin
mynum := 40001;
loop
insert into cs (wzh,dygd,sbgxxh,sbgxlb,zyjz,jcsz,jcrq,jcyqbh,bjnd,gywd,gyyl,wd,sd,fs,jcry)
values (mynum,'气分','','阀门','粗丙烯','10','2004/4/13','102446651','1','62.4','2.1','27','50','0.1','严龙');
exit when mynum = 40061;
mynum := mynum + 1;
end loop;
end;
可能由于wzh在数据库中是字符串字段
如果将整数转换成字符串后插入
谢谢
谢谢
谢谢insert(wzh,....) values(to_char(mynum),...)
mynum number(5);
begin
mynum := 40001;
loop
exit when mynum = 40061; --这句放在这里
insert into cs (wzh,dygd,sbgxxh,sbgxlb,zyjz,jcsz,jcrq,jcyqbh,bjnd,gywd,gyyl,wd,sd,fs,jcry)
values (mynum,'气分','','阀门','粗丙烯','10','2004/4/13','102446651','1','62.4','2.1','27','50','0.1','严龙');
mynum := mynum + 1;
exit when mynum = 40061; --或放在这里
end loop;
end;40061这条不会被插入
hewei2003() 认为 :如果你的'2004/4/13'在数据库中是date数据类型,那么要用to_date('2004/4/13','yyyy-mm-dd')
我想应该是解决方法吧 .