oracle批量更新
update scott.daily_market_01 a
set (
Z1_line05 ,
Z1_line10 ,
Z1_line20 ,
Z1_line40 ,
z1_va_ratio
)=
(
select
line05,
line10,
line20,
line40,
va_ratio
from(
select scott.daily_market.code,scott.daily_market.trading_day,scott.daily_market.voturno
原创
2020-11-20 01:17:03 ·
127 阅读 ·
0 评论