sql_id_looping.sql

DECLARE 

x number;
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=100;

 	x:= 0;

 	LOOP x := x+1;

 	IF x > 5 THEN exit;

 	END IF;

dbms_output.put_line('Nama karyawan adalah: ' || v_fname || ' ' || v_lname || ' Looping ke-' || x);

 END LOOP;

 END;