如下,两个标红的字段是同一个么?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;