摘要：
1.通过提取数据declare v_result sys_refcursor;v_id int;v_name varchar2(20);beginopen v_result for select empno,ename from emp;loopfetch v_result into v_id,v_name;exit when v_result%notfound;dbms_output.put_line('列id的值：'||to_char(v_id));dbms_output.put_line('列name的值：'||v_name);end loop;close 阅读全文
