17,090
社区成员
发帖
与我相关
我的任务
分享
declare
CURSOR l_c IS select col1,col2 from table1;
Begin
FOR i IN l_c LOOP
dbms_output.put_line(i.col1||' '||i.col2);
END LOOP;
End;
/
sqlplus 下执行:
CREATE OR REPLACE PROCEDURE proAA
IS
CURSOR l_c IS select col1,col2 from table1;
Begin
FOR i IN l_c LOOP
dbms_output.put_line(i.col1||' '||i.col2);
END LOOP;
End;
/
SET serveroutput ON
EXEC proaa;