USING FOR LOOP FETCH EMPLOYEE DETAILS FROM EMP TABLE
DECLARE
CURSOR C IS SELECT * FROM EMP;
BEGIN
FOR I IN C LOOP;
DBMS_OUTPUT.PUT_LINE(I.EMPNO||' '||I.ENAME||' '||I.SAL);
END LOOP;
END;
DECLARE
CURSOR C IS SELECT * FROM EMP;
BEGIN
FOR I IN C LOOP;
DBMS_OUTPUT.PUT_LINE(I.EMPNO||' '||I.ENAME||' '||I.SAL);
END LOOP;
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.