oracle merge 使用记录
merge into table t
using (select 'key' key from dual ) t2
on (t2.key = t.key)
when matched then
update set t.x = xxx, t.y = yyy,t.date = to_date(?, 'yyyy-mm-dd hh24:mi:ss')
when not matched then
in...
原创
2018-09-15 14:13:16 ·
215 阅读 ·
0 评论