exceptionquery.sql

DECLARE 
 nama varchar2(100);
 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 last_name='Chan';

exception
when no_data_found then
dbms_output.put_line('Data karyawan tidak ditemukan.');

 END;