cursor 2

DECLARE
CURSOR C1 IS
SELECT FIRST_NAME,LAST_NAME FROM hr.EMPLOYEES;
e_FIRST_NAME hr.EMPLOYEES.FIRST_NAME%TYPE;
E_LAST_NAME hr.EMPLOYEES.LAST_NAME%TYPE;
BEGIN
OPEN C1;
FETCH
C1 INTO e_FIRST_NAME,E_LAST_NAME;
DBMS_OUTPUT.PUT_LINE(e_FIRST_NAME || ' ' || E_LAST_NAME);
CLOSE C1;
END;


SELECT * FROM HR.DEPARTMENTS;

DECLARE
DEP_VAR HR.DEPARTMENTS%ROWTYPE;
CURSOR DEP_CURSOR IS
SELECT * FROM HR.DEPARTMENTS;
BEGIN
OPEN DEP_CURSOR;
FETCH DEP_CURSOR INTO DEP_VAR;
DBMS_OUTPUT.put_line( DEP_VAR.DEPARTMENT_ID || ' ' || DEP_VAR.DEPARTMENT_NAME || ' ' || DEP_VAR.MANAGER_ID || ' ' ||DEP_VAR.LOCATION_ID);
CLOSE DEP_CURSOR;
END;


DECLARE
DEP_VAR HR.DEPARTMENTS%ROWTYPE;
CURSOR DEP_CURSOR IS
SELECT * FROM HR.DEPARTMENTS;
BEGIN
OPEN DEP_CURSOR;
FETCH DEP_CURSOR INTO DEP_VAR;
DBMS_OUTPUT.put_line( DEP_VAR.DEPARTMENT_ID || ' ' || DEP_VAR.DEPARTMENT_NAME || ' ' || DEP_VAR.MANAGER_ID || ' ' ||DEP_VAR.LOCATION_ID);
CLOSE DEP_CURSOR;
END;

SELECT * FROM HR.JOBS;

DECLARE
CURSOR JOB_CURSOR IS
SELECT * FROM HR.JOBS;
JOB_REC JOB_CURSOR%ROWTYPE;
BEGIN
IF NOT JOB_CURSOR%ISOPEN THEN
OPEN JOB_CURSOR;
END IF;
LOOP
FETCH JOB_CURSOR INTO JOB_REC;
DBMS_OUTPUT.PUT_LINE(JOB_REC.JOB_ID || ' ' || JOB_REC.JOB_TITLE || ' ' || JOB_REC.MIN_SALARY || ' ' || JOB_REC.MAX_SALARY);
END LOOP;
END;