sql_with_exception.sql

declare
v_fname employees.first_name%type;
v_lname employees.last_name%type;

begin
select first_name, last_name into v_fname, v_lname from employees where employee_id=1000;
dbms_output.put_line('Nama depannya adalah: ' || v_fname );
dbms_output.put_line('Nama belakangnya adalah: ' || v_lname );
exception
when no_data_found then
dbms_output.put_line('Data karyawan tidak ditemukan.');
end;