Thursday, 18 February 2016

PL/SQL PROGRAM ON CURSOR AND ITS ATTRIBUTES

Q)WRITE A PL/SQL BLOCK DISPLAYS  THE WORKING LOCATIONS WHEN JOB PASSED AS INPUT VALUE?
A)DECLARE
    LOC DEPT.LOC%TYPE;
    CURSOR C IS SELECT LOC FROM DEPT WHERE DEPTNO=(SELECT DEPTNO FROM
    EMP WHERE JOB='&JOB');
    BEGIN
    OPEN C;
    LOOP
    FETCH C INTO  LOC;
    IF C%FOUND THEN
    DBMS_OUTPUT.PUT_LINE('LOCATION FOR'||' '||JOB||' '||'IS'||' '||LOC);
    ELSE
    EXIT;
    END IF;
    END LOOP;
    CLOSE C;
    END;

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.