Aritra Chattopadhyay
said:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
| Great :) |
| DECLARE CURSOR C1 IS SELECT * FROM EMP; EMP_REC EMP%ROWTYPE; BEGIN OPEN C1; LOOP FETCH C1 INTO EMP_REC; DBMS_OUTPUT.PUT_LINE(EMP_REC.EMPNO ||' '||EMP_REC.ENAME ||' '||EMP_REC.SAL); EXIT WHEN C1%ROWCOUNT >10; END LOOP; CLOSE C1; END; |
| < Prev | Next > |
|---|
|