dokuwiki

declare
fn varchar2(100);
ln varchar2(100);
v_bonus number;
sal number;
begin
fn := 'Mark';
ln := 'Hofstetter';
sal := 144;
v_bonus := 111;
merge into copy_employees ce
using (select 1 from dual) 
on (ce.first_name = :fn and ce.last_name = :ln)
when matched then update set 
salary = :sal, bonus = :v_bonus
when not matched then
insert
(employee_id, first_name, last_name, salary, bonus, hire_date)
values
(employees_seq.nextval,
:fn,
:ln,
:sal,
:v_bonus,
sysdate);
end;
/