如下,两个标红的字段是同一个么?Select nvl(Max(detailnum1),0) Into imax1 From dlmis.tzrec1910D32392 Where recid=iRecID;
insert into dlmis.tzrec1910D32392(recid,DETAILNUM1,seniordetailnum,GNFQMC,YDMJ)
select iRecID,imax1+rownum,idetailnum,SUBAREA_NAME,add_Area
from dlmlr.PERIOD_OFFER
Where bpl_guid=sbplguid And SUBAREA_NAME Is Not Null;
insert into dlmis.tzrec1910D32392(recid,DETAILNUM1,seniordetailnum,GNFQMC,YDMJ)
select iRecID,imax1+rownum,idetailnum,SUBAREA_NAME,add_Area
from dlmlr.PERIOD_OFFER
Where bpl_guid=sbplguid And SUBAREA_NAME Is Not Null;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货