Oracle merge的多组匹配条件该怎么写?
比如我是想要这种多组条件:
[code="sql"]
merge into whiskytest x
using (select t.*, t.rowid from whiskytest t) t
on (x.remark = t.remark and x.updater = t.updater) or (x.remark is null and x.updater = t.updater) or (x.remark is null and x.updater is null)
when matched then
update set x.seq=t.seq;
[/code]
当然这样写是错误的,只是想表达on条件那里的多组条件组合要怎么写!!
但是又不等同于这种on写法:
[code="sql"]
merge into whiskytest x
using (select t.*, t.rowid from whiskytest t) t
on ((x.remark = t.remark or x.remark is null) and (x.updater = t.updater or x.updater is null))
when matched then
update set x.seq = t.seq;
[/code]
请指教~~~~~~