表很简单的. 我SQL雏形写出来了. 您参考下. update set update prpdmemallocation set manualcomcode = 'manualcomcode' manualperson = 'manualperson ' manualtime = trunc(sysdate) resourcetype = '3' status = '2' where memberid in (select r.memberid from BasMemberInfo r inner join BASCARINFO car on r.memberid = car.memberid left join basgraderule s on r.graderuleid = s.graderuleid WHERE EXISTS (SELECT 1 FROM SYS_BRANCH WHERE (TREEPATH LIKE '%' || '1' || ';%' OR BRANCHCODE = '42010000') AND BRANCHCODE = car.ALLOTORGAN) and rownum <= 60 and rownum > 0)
我SQL雏形写出来了.
您参考下.
update
set update prpdmemallocation
set manualcomcode = 'manualcomcode' manualperson = 'manualperson '
manualtime = trunc(sysdate) resourcetype = '3'
status = '2'
where memberid in (select r.memberid
from BasMemberInfo r
inner join BASCARINFO car
on r.memberid = car.memberid
left join basgraderule s
on r.graderuleid = s.graderuleid
WHERE EXISTS (SELECT 1
FROM SYS_BRANCH
WHERE (TREEPATH LIKE '%' || '1' || ';%' OR
BRANCHCODE = '42010000')
AND BRANCHCODE = car.ALLOTORGAN)
and rownum <= 60
and rownum > 0)
and rownum <= 60
这个60就是填写的分配条数
and rownum > 0这种条件最好不要这么写