oracle中存储过程,报错select没有into,能不能帮忙看看,怎么改一次把表中的信息掉出来

create or replace procedure m_s_3(m_code number,n_code number)
is
begin
select * from s_3 where code between m_code and n_code order by code desc;
commit ;

end;
最新回答
古巷

2024-10-16 08:00:12

create or replace procedure m_s_3(m_code number,n_code number)
is
begin
for c in (
select * from s_3 where code between m_code and n_code order by code desc) loop

--你的代码,当前记录的值 使用 c.column_name 访问

end loop;
commit ;

end;