WAP to display all managers data from emp table using cursor for loop

·

1 min read

DECLARE
 CURSOR c1 IS SELECT * FROM emp 
WHERE job = 'MANAGER';
BEGIN
 DBMS_OUTPUT.ENABLE;
 FOR i IN c1 LOOP
 DBMS_OUTPUT.PUT_LINE(i.empno || ' 
' || i.ename || ' ' || i.sal);
 END LOOP;
END;