Question

oracle中open cursor for 和for cursor in有什么区别

Answer 1

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)
AS
BEGIN
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;