You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Feb 18, 2021. It is now read-only.
CREATE OR REPLACE PACKAGE BODY abc
IS
CURSOR cur_rows (num_rows NUMBER)
IS
SELECT tname
FROM tab
WHERE ROWNUM < num_rows;
PROCEDURE x
IS
y VARCHAR2 (100);
BEGIN
OPEN cur_rows (5);
LOOP
FETCH cur_rows
INTO y;
EXIT WHEN cur_rows%NOTFOUND;
DBMS_OUTPUT.put_line (y);
END LOOP;
END x;
END abc;