- merge into membernum using (select count(id) count from membernum where phone = 1111 and ringid = 22 ) num2 on (num2.count <> 0 )
- when matched then update set balance = balance +222, totalnum = totalnum + 2222
- when not matched then insert (id, phone,ringid,totalnum,balance)
- values (SEQ_MEMBERNUM.nextval, 11111 ,2222 , 2222 , 2222)
本sql语句对于Oracle9i以前的版本不可以。