contoh exeption

declare
a employees.employee_id%type;
b employees.first_name%type;
c employees.salary%type;
d departments.department_name%type;


begin
a:='&id';

select employee_id, salary
into a, c
from employees natural join jobs
where employee_id = a;
dbms_output.put_line('gaji'||b||' adalah USD '||c);

if(c>2000)then
dbms_output.put_line('gaji besar');



elsif(c<2000)then
dbms_output.put_line('gaji kecil');

elsif(c=2000)then
dbms_output.put_line('gaji kecil');
end if;
exception
when no_data_found then
dbms_output.put_line('Data karyawan ' ||a|| ' tidak ditemukan ');



end;
/