创建一个表:分数段--fenshu;人数----renshu
create table rank(fenshu,renshu);给这个表插入数据:
insert into rank values('不及格','30');
insert into rank values('60~70','20');
insert into rank values('70~80','5');创建一个存储过程:
create procedure sp_rank
as
begin
select * from rank;
end出现错误:there is no more information about error!这就是我的问题。
create table rank(fenshu,renshu);给这个表插入数据:
insert into rank values('不及格','30');
insert into rank values('60~70','20');
insert into rank values('70~80','5');创建一个存储过程:
create procedure sp_rank
as
begin
select * from rank;
end出现错误:there is no more information about error!这就是我的问题。
as
a rank%rowtype;
begin
select * into a from rank;
end sp_rank;
as
begin
for i in (select * from rank) loop
dbms_output.put_line(i.fenshu||' '||i.renshu);
end loop;
end
as
begin
for i in (select * from rank) loop
dbms_output.put_line(i.fenshu||' '||i.renshu);
end loop;
end;