Oracle 将一个表中的字段值更新到另一个表的字段中
Oracle 将一个表中的字段值更新到另一个表的字段中:
- --使用where exists,则当数据存在时才会更新
- update sysrole role set system_name = (select system_name from temp_sysrole temp where role.rolename=temp.rolename)
- where exists
- (select system_name from temp_sysrole temp where role.rolename=temp.rolename);
相关推荐
IT之家 2020-03-11
graseed 2020-10-28
zbkyumlei 2020-10-12
SXIAOYI 2020-09-16
jinhao 2020-09-07
impress 2020-08-26
liuqipao 2020-07-07
淡风wisdon大大 2020-06-06
yoohsummer 2020-06-01
chenjia00 2020-05-29
baike 2020-05-19
扭来不叫牛奶 2020-05-08
hxmilyy 2020-05-11
黎豆子 2020-05-07
xiongweiwei00 2020-04-29
Cypress 2020-04-25
冰蝶 2020-04-20