oracle merge

oracle merge.sql

merge into tims_idr_agent t
using (select 1 from DUAL) s
on (t.id = p_id AND t.audit_cycle = p_audit_cycle)
when matched then
  update set t.name = 'Alan1',t.phone = '-2932x',t.email = 'Alan@v1',t.category = 'Domestic1'
when not matched THEN
  INSERT (audit_cycle,ID,NAME,phone,email,category)
  VALUES(p_audit_cycle,p_id,p_name,p_phone,p_email,p_category);