17,086
社区成员
发帖
与我相关
我的任务
分享
DECLARE
v_xuehao t.xuehao%TYPE;
v_xingming t.xingming%TYPE;
v_xingming t.chengji%TYPE;
CURSOR a IS select xuehao,xingming,chengji from t
BEGIN
OPEN a;
LOOP
FETCH a INTO v_xuehao,v_xingming,v_xingming;
dbms_output.put(v_xuehao||v_xingming||v_xingming);
EXIT WHEN a%NOTFOUND;
END;
CREATE OR REPLACE PROCEDURE ProcedureTest2 IS
-- 定义光标
CURSOR c1 IS SELECT * FROM t;
BEGIN
-- 光标FOR循环
FOR r IN c1
LOOP
--对r,即每一条记录进行使用和处理。
END LOOP;
END ProcedureTest2;