oracle得快的更新语法,oracle更新操作

ORACLE多表链接更新语法怎么写!!!!!

update Awork set name = （select b.name from Awork a inner join Bwork b on a."uid" = b."uid"

where a."uid" = 23 and a.XXX = '考试'）

oracle更新语法，求大神帮优化

合并为一个就好了,写法上简单了，就是不知道具体运行起来会不会快。毕竟多了一个运算。不过只扫描一遍，应该会快一点吧。

UPDATE QL_EXPORT_CONFIRM

SET STATUS = '1'

WHERE ARTICLE_NO||SHEET_ID=(SELECT T1.ARTICLE_NO||T1.SHEET_ID

FROM QL_EXPORT_CONFIRM T1

JOIN QL_BK_EXPORT T2

ON T1.LOCNO = T2.LOCNO AND T1.OWNER_NO = T2.OWNER_NO AND

T1.SHEET_ID = T2.SHEET_ID AND T1.ARTICLE_NO = T2.ARTICLE_NO AND

T1.STATUS = '0' AND T1.SHEET_ID LIKE 'JA6%' AND

T2.ORDERLINENO = '106') and?STATUS = '0'

oracle更新语句语法

update tskuplu a set a.pluname = a.pluname ||

(select b.lxname from tBasFlContent b

where b.flcode = '9001'

and b.lxcode = a.Udp3)

where a.plucode like '0%'

and a.udp3 in ('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K');

or

UPDATE tskuplu t

SET t.pluname = (SELECT a.pluname || b.lxname

FROM tskuplu a, tBasFlContent b

WHERE b.flcode = '9001'

AND b.lxcode = a.Udp3

AND a.plucode LIKE '0%'

AND a.udp3 IN

('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K')

AND a.Udp3 = t.Udp3)

oracle多表数据的更新语句如何写sql？

Oracle没有update from语法

--利用视图 进行多表更新

UPDATE(

select a.姓名 aname,c.姓名 bname

from stuInfo1 a

inner join 表2 b

on a.id=b.id

inner join 表3 c

on b.id=c.id

)

set bname=aname;

oracle update 语法

UPDATE 8001

SET b = NULL WHERE a = 1 AND b = 0

表名字用数字，很奇怪哦

oracle Update语句

因为where 前面已经有一个 a.code=b.oldcode 条件子句， 条件子句与条件子句之间只能用or 或者and ,而不能再用where