create table emp as
select 7782 empno, 'CLARK' ename from dual;
CREATE GLOBAL TEMPORARY TABLE emp
(empno CHAR(20),
ename CHAR(20))
ON COMMIT DELETE ROWS;
insert into emp
(empno,ename) values('1','CLARK');
select * from emp;
create or replace procedure details (p_cursor out sys_refcursor)
is
begin
open p_cursor for
select empno, ename
from emp;
end;
/
declare
rc sys_refcursor;
l_empno emp.empno%type;
l_ename emp.ename%type;
begin
details (rc);
loop
fetch rc into l_empno, l_ename;
exit when rc%notfound;
dbms_output.put_line(l_empno||' - '|| l_ename);
end loop;
end;
/
使用 Oracle SQL Developer 我创建了上面的脚本,希望看到结果,但我没有看到查询的任何结果,我看到的是
如何打印/显示结果
默认情况下,输出被禁用。您可以通过以下方式启用它: