测试代码如下:
declare cursor c_test is
select sysdate as c_time, 1 as c_no, 'test' as descr from dual;--rec c_test%rowtype;
r c_test%rowtype;
begin
for rec in c_test
loop
r := rec;
dbms_output.put_line(r.c_time||'|'||r.descr);
end loop;
end;
测试代码如下:
declare cursor c_test is
select sysdate as c_time, 1 as c_no, 'test' as descr from dual;end;