可以这么写: for cur in (select F_ID,F_name from t_name) loop dbms_output.put_line(cur.F_ID,F_name); end loop;
for cur in (select F_ID,F_name from t_name) loop dbms_output.put_line(cur.F_ID,cur.F_name); end loop;
写得急了。 for cur in (select F_ID,F_name from t_name) loop dbms_output.put_line(cur.F_ID||','||F_name); end loop;
CREATE OR REPLACE PROCEDURE "SYS"."TEST1" IS BEGIN for cur in (select F_ID,name from T_TEST) loop dbms_output.put_line(cur.F_ID||','||F_name); end loop; END TEST1;这样写是否正确
--楼主要的是这个吧 create or procedure sp_test( rst out sys_refcursor) is begin open rst for select F_ID,F_name from t_name; end;
不知道楼主是什么意思,如果是游标的话可以 for v in (select ) 如果是取一条记录的话可以放到变量里 select F_ID,F_name into 变量1,变量2 from t_name; 如果取多条记录可以放到记录变量里 select id,name bulk collect into 记录变量...
返回一个表记录集,却实没有ms sql强呀。
发表于:2007-09-10 08:42:335楼 得分:0 --楼主要的是这个吧 create or procedure sp_test( rst out sys_refcursor) is begin open rst for select F_ID,F_name from t_name; end; 这个存储过程在toad中如何执行?
for cur in (select F_ID,F_name from t_name) loop
dbms_output.put_line(cur.F_ID,F_name);
end loop;
dbms_output.put_line(cur.F_ID,cur.F_name);
end loop;
for cur in (select F_ID,F_name from t_name) loop
dbms_output.put_line(cur.F_ID||','||F_name);
end loop;
BEGIN
for cur in (select F_ID,name from T_TEST) loop
dbms_output.put_line(cur.F_ID||','||F_name);
end loop;
END TEST1;这样写是否正确
create or procedure sp_test( rst out sys_refcursor) is
begin
open rst for select F_ID,F_name from t_name;
end;
for v in (select ) 如果是取一条记录的话可以放到变量里
select F_ID,F_name
into 变量1,变量2 from t_name;
如果取多条记录可以放到记录变量里
select id,name bulk collect into 记录变量...
--楼主要的是这个吧
create or procedure sp_test( rst out sys_refcursor) is
begin
open rst for select F_ID,F_name from t_name;
end;
这个存储过程在toad中如何执行?