oracle中open cursor for 和for cursor in的区别如下：open cursor for 是直接打开游标查询结果，适用于单表查询，结果集一般不会太大。for cursor in是从大量数据中循环获取满足条件的记录，放入游标1、open cursor for 用法：CREATE OR REPLACE PROCEDURE AMLS.TEST(C_RES OUT SYS_REFCURSOR) ASBEGIN OPEN C_RES FOR //打开游标 SELECT * FROM MAJOR.TB_CUST_CODE; END TEST; 2、for cursor in用法V_CURSOR SYS_REFCURSOR; V1 MAJOR.TB_CUST_CODE%ROWTYPE;BEGIN AMLS.TEST(V_CURSOR); LOOP FETCH V_CURSOR INTO V1; EXIT WHEN V_CURSOR%NOTFOUND; DBMS_OUTPUT.PUT_LINE(V1.CUST_NAME); END LOOP;
