1.Oracle使用function管道输出结果集,只能输出数值型
create or replace function test_fun(
a in varchar2,b in varchar2
)
return table_type pipelined
is
v row_type;--定义v为行对象类型
begin
for thisrow in (select a, b from mytable where col1=a and col2 = b)
loop
v := row_type(thisrow.a, thisrow.b);
pipe row (v);
end loop;
return;
end;
2.