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)