看你的例子好像想这样 create procedure dept_employees(dept in varchar2) is deptlist varchar2(10);//***** cursor a(t_name varchar2) is select name from name where name=t_name;//你是不是想传进参数? begin for deptlist in a(dept) loop dbms_output. put_line(deptlist.name); end loop; end dept_employees;
create procedure dept_employees(dept in char) is begin for deptlist in (select name from name where name=cui) loop dbms_output.put_line(deptlist.name); end loop; end dept_employees;
create procedure dept_employees(dept in varchar2)
is
deptlist varchar2(10);//*****
cursor a(t_name varchar2) is select name from name
where name=t_name;//你是不是想传进参数?
begin
for deptlist in a(dept)
loop
dbms_output. put_line(deptlist.name);
end loop;
end dept_employees;
is
begin
for deptlist in (select name from name
where name=cui) loop
dbms_output.put_line(deptlist.name);
end loop;
end dept_employees;
select name from name where name='cui'