DECLARE
v_employee_id NUMBER;
v_last_name VARCHAR(255);
v_salary NUMBER;
v_bonus NUMBER;
v_counter NUMBER := 100;
BEGIN
WHILE v_counter <= 150 LOOP
SELECT employee_id, last_name, salary INTO v_employee_id, v_last_name, v_salary FROM hr.employees WHERE employee_id = v_counter;
IF v_salary > 15000 THEN v_bonus := v_salary*0.1;
ELSIF v_salary < 15000 THEN v_bonus := v_salary*0.05;
END IF;
DBMS_OUTPUT.PUT_LINE('ID: ' || v_employee_id || ' | Last Name: '|| v_last_name || ' | Salary: ' || v_salary || ' | Bonus: ' || v_bonus || ' |');
v_counter := v_counter+1;
END LOOP;
END;