条件更新或插入 

merge into SYS_SERVICE_FIRM_REF  t
using dual on ( t.firm_id = '1181d78bf12048ff8a714a1ccb56c3e2' and service_id ='2' )  
 when not matched then insert (id,service_id,firm_id) values (1,2,'111111')
posted @ 2020-01-10 14:25  剑小新  阅读(179)  评论(0)    收藏  举报