declare
type fy_serv_t_record is record (
v_serv_name fy_serv_t.serv_name%type);
serv_record fy_serv_t_record;begin
select serv_name into serv_record.v_serv_name from fy_serv_t;
dbms_output.put_line ( serv_record.v_serv_name);
end;
请大大们帮忙看下上面的代码,PL SQLDEV 运行提示:
exact fetch returns more than requested number of rows请问,record 不是可以存储不止一条记录的么?
type fy_serv_t_record is record (
v_serv_name fy_serv_t.serv_name%type);
serv_record fy_serv_t_record;begin
select serv_name into serv_record.v_serv_name from fy_serv_t;
dbms_output.put_line ( serv_record.v_serv_name);
end;
请大大们帮忙看下上面的代码,PL SQLDEV 运行提示:
exact fetch returns more than requested number of rows请问,record 不是可以存储不止一条记录的么?
declare
type fy_serv_t_record is record (v_serv_name fy_serv_t.serv_name%type);
serv_record fy_serv_t_record;
begin
for serv_record in (select serv_name from fy_serv_t)
loop
dbms_output.put_line (serv_record.serv_name);
end loop;
end;
你可以放心用wkc168的方法。我已经测试成功了。
wkc168那样写就挺好