plsqldev建表_PLsqldev用while循环输出一个表中的内容
问题补充：
可被骂，被打，被伤害，只要能把我教会。
补充：输出Student表，在线等，急啊，马上交作业了。补充：declare s number;begin select count(*) into s from student; if s>=1 then for s in (Select * from student) loop dbms_output.put_line(s.sno||s.sname||s.ssex||s.sage||s.sdept); end Loop; end if;end;你们一群坑货，还是得靠自己，哼。最佳答案
create or replace procedure sel_stu(var_dep in varchar,
num_sno out student.sno%type,
var_sna out student.sname%type,
var_sco out student.score%type,
var_depid out student.department_id%type) is
begin
select sno, sname, score, department_id
into num_sno, var_sna, var_sco, var_depid
from student
where department = var_dep;
end sel_stu;
最佳答案由网友 LX271182736 提供
其他回答
暂无其它回答!
