I'm running a merge statement but I want the update to happen only if there is exactly one row matching.
merge into mergetest using dual on (a = 1) when matched then update set b = b+1;
I know I can include a
where clause at the end, but I have no idea what to do. Group functions are not allowed, so
count(*) = 1 doesn't work.