declare
v_emp employees%rowtype;
begin
select * into v_emp from employees where lastname = 'smith';
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.lastname || ' ' ||
v_emp.salary);
exception
when no_data_found then
insert into employees
(employeeid, lastname, salary, email, hiredate, jobid, departmentid)
values
(2010,
'smith',
7500,
'smith@neusoft.edu.cn',
to_date('2000-10-5', 'yyyy-mm-dd', 'AD_VP', 50));
when too_many_rows then
for v_emp in (select * from employees where lastname = 'smith') loop
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.lastname || ' ' ||
v_emp.salary);
end loop;
end;
v_emp employees%rowtype;
begin
select * into v_emp from employees where lastname = 'smith';
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.lastname || ' ' ||
v_emp.salary);
exception
when no_data_found then
insert into employees
(employeeid, lastname, salary, email, hiredate, jobid, departmentid)
values
(2010,
'smith',
7500,
'smith@neusoft.edu.cn',
to_date('2000-10-5', 'yyyy-mm-dd', 'AD_VP', 50));
when too_many_rows then
for v_emp in (select * from employees where lastname = 'smith') loop
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.lastname || ' ' ||
v_emp.salary);
end loop;
end;