oracle的游标备忘 显示游标 declare
cursor cur_sel is select t.month_id,t.prov_id from table t where rownum < 100;
var_1 table.Month_Id%type;
var_2 table.Prov_Id%type;
begin
open cur_sel;
loop
fetch cur_sel into var_1,var_2;
exit when cur_sel%notfound;
db…
CREATE OR REPLACE PROCEDURE PRC_LJ IS CURSOR C_EMP IS --声明显式游标 SELECT EMPNO,ENAME FROM EMP; C_ROW C_EMP%ROWTYPE; --定义游标变量,该变量的类型为基于游标C_EMP的记录 BEGIN --For 循环 FOR C_ROW IN C_EMP LOOP DBMS_OUT…