merge into e_audit_course_price t1
using (select :contentId as contentid from dual) t2
on (t1.contentid = t2.contentid)
when matched then
update set t1.onlinenum = t1.onlinenum + 1
when not matched then
insert ( t1.ID,t1.CONTENTID,t1.CHARGEMODE,t1.INFOFEE,t1.INFOFEECHAPTERID,
t1.REJECTREASON,t1.AUDITSTATUS,t1.APPLYTIME)
values (:contentId, 1, :type)