oracle两张表关联更新
UPDATE detail a
SET settle_status = ‘7777’
WHERE EXISTS
(SELECT 1
FROM abc b
WHERE b.oppaccno = a.cracc_no
)
首页
› oracle性能优化 › oracle两表关联更新
oracle两张表关联更新
UPDATE detail a
SET settle_status = ‘7777’
WHERE EXISTS
(SELECT 1
FROM abc b
WHERE b.oppaccno = a.cracc_no
)
发表评论