lab5

 DECLARE

 v_E_id Employee.E_id%TYPE;

 v_E_name Employee.E_name%TYPE;

 v_Age Employee.Age%TYPE;

 v_Salary Employee.Salary%TYPE;

 CURSOR emp_cursor IS

 SELECT E_id, E_name, Age, Salary

 FROM Employee;

BEGIN

 OPEN emp_cursor;

 LOOP

 FETCH emp_cursor INTO v_E_id, v_E_name, v_Age, v_Salary;

 EXIT WHEN emp_cursor%NOTFOUND;

 DBMS_OUTPUT.PUT_LINE('Employee ID: ' || v_E_id || ', Employee Name: ' || v_E_name 

|| ', Age: ' || v_Age || ', Salary: ' || v_Salary);

 END LOOP;

 CLOSE emp_cursor;

END;