create or replace procedure EmpInfo (cursor out empcsr)
is
begin
open empcsr for select e.ename,d.* from emp e,dept d where e.deptno = d.deptno and e.sal>4000;
end;0/0 PL/SQL: Compilation unit analysis terminated
1/31 PLS-00201: 必须说明标识符 'EMPCSR'
is
begin
open empcsr for select e.ename,d.* from emp e,dept d where e.deptno = d.deptno and e.sal>4000;
end;0/0 PL/SQL: Compilation unit analysis terminated
1/31 PLS-00201: 必须说明标识符 'EMPCSR'
is
begin
open empcsr for select e.ename,d.* from emp e,dept d where e.deptno = d.deptno and e.sal>4000;
end;