我 以前在MS SQLSERVER上的语句,放到ORACLE9I 上执行不了
update user_hcdetail set pno='200610100001' from
user_hcdetail b,
cpcshtins c,
cpcwf d,
cpcwfproc_v e
Where
b.shtinsid = c.shtinsid
and c.wfid=d.wfid
and d.wfid=e.wfid
and d.currprocid=e.procid
and e.procid=6
and (length(rtrim(ltrim(b.pno)))<1 or b.pno is NULL)
update user_hcdetail set pno='200610100001' from
user_hcdetail b,
cpcshtins c,
cpcwf d,
cpcwfproc_v e
Where
b.shtinsid = c.shtinsid
and c.wfid=d.wfid
and d.wfid=e.wfid
and d.currprocid=e.procid
and e.procid=6
and (length(rtrim(ltrim(b.pno)))<1 or b.pno is NULL)