dokuwiki

This is an old revision of the document!

---

merge into accountants
using (select 1 from dual)
on (last_name = :ln and first_name = :fn)
when matched then update set salary = :salary
when not matched then 
  insert 
    (first_name,
    last_name,
    salary)
    values (
    :fn,
    :ln,
    :salary)