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;
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.