1 declare
2 type t1 is record(name emp.ename%type,
3 sll emp.sal%type);
4 t2 t1;
5 cursor c_cursor is select ename,sal from emp where rownum <=14;
6 /*v_ename emp.ename%type;
7 v_sal emp.sal%type;*/
8 begin
9 open c_cursor;
10 fetch c_cursor into t2;
11 while c_cursor%found loop
12 dbms_output.put_line(t2.name||':'||t2.sll);
13 fetch c_cursor into t2;
14 end loop;
15 close c_cursor;
16 end;
17 /
2 type t1 is record(name emp.ename%type,
3 sll emp.sal%type);
4 t2 t1;
5 cursor c_cursor is select ename,sal from emp where rownum <=14;
6 /*v_ename emp.ename%type;
7 v_sal emp.sal%type;*/
8 begin
9 open c_cursor;
10 fetch c_cursor into t2;
11 while c_cursor%found loop
12 dbms_output.put_line(t2.name||':'||t2.sll);
13 fetch c_cursor into t2;
14 end loop;
15 close c_cursor;
16 end;
17 /
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26585184/viewspace-742500/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
