set serveroutput on Declare v_servnumber long; begin select servnumber into v_servnumber from subscriber where status = 'US10' and active = '1' and rownum <2; dbms_output.put_line ('可用的号码是' || v_servnumber ); end ; /这个pl/sql 现在只能返回一条记录,如果想让他返回10条记录是不是就必需用游标啦? 如果使用游标可以实现的话,要怎么写?多谢了!
for cur1 in (select servnumber from subscriber where status = 'US10' and active = '1')loop v_servnumber :=cur1.servnumber; dbms_output.put_line(v_servnumber); end loop;
declare cursor c_1 is select servnumber from subscriber where status = 'US10' and active = '1'; v_servnumber subscriber.servnumber%type; begin for cur1 in c_1 loop v_servnumber :=cur1.servnumber; dbms_output.put_line(v_servnumber); end loop; end;你自己google一下的 这样的资料一搜一大堆
Declare
v_servnumber long;
begin
select servnumber
into v_servnumber
from subscriber where status = 'US10' and active = '1' and rownum <2;
dbms_output.put_line ('可用的号码是' || v_servnumber );
end ;
/这个pl/sql 现在只能返回一条记录,如果想让他返回10条记录是不是就必需用游标啦?
如果使用游标可以实现的话,要怎么写?多谢了!
from subscriber where status = 'US10' and active = '1')loop
v_servnumber :=cur1.servnumber;
dbms_output.put_line(v_servnumber);
end loop;
cursor c_1 is select servnumber
from subscriber where status = 'US10' and active = '1';
v_servnumber subscriber.servnumber%type;
begin
for cur1 in c_1 loop
v_servnumber :=cur1.servnumber;
dbms_output.put_line(v_servnumber);
end loop;
end;你自己google一下的
这样的资料一搜一大堆