insert后的数据顺序和insert前SELECT出来的数据顺序不一样,请高人指点下
环境:pb90+oracle817
insert into MAIN (spbm,bs,lsj,bmh,xstm,bzq,name)
select a.code,'0',b.lsj,'','',a.BZQTS ,a.name
from commod a,COMMOD_GZ_GYS b
where (a.unit='公斤' or a.unit='KG' or a.unit='千克' or a.unit ='1000克')
and a.status='Y' and a.splb<>'9' AND a.CODE=b.CODE(+) AND b.MC=FGETMC() order by a.rowid asc ;
插入完后,select * from main 表的结果顺序如下图
spbm bs lsj .....
109834
109835
109836
109837
109715
而用select a.code,'0',b.lsj,'','',a.BZQTS ,a.name
from commod a,COMMOD_GZ_GYS b
where (a.unit='公斤' or a.unit='KG' or a.unit='千克' or a.unit ='1000克')
and a.status='Y' and a.splb<>'9' AND a.CODE=b.CODE(+) AND b.MC=FGETMC() order by a.rowid asc ;
顺序是
spbm bs lsj........
109715
109716
109717
109718
109719
109720 这个顺序是我想要的顺序,不知道为什么,INSERT后顺序就变了,是在是搞不动。游标也试过了,调试的时候取的顺序也是109715,109716......,可是插到MAIN表中,结果就变了,请高手指导下。谢谢