--1、定义一个行集的格式 create or replace type type_1 AS OBJECT(a number,b varchar2(200)); --2、为上一步定义的类型定义一个集合类型 CREATE TYPE t_1 AS TABLE OF type_1; --3、创建表 create table t_obj as select * from dba_objects;--4、pipelined 函数 create or replace function pipe_test return t_1 PIPELINED ASbegin FOR F IN (select a.object_id, a.object_name from t_obj a) LOOP
pipe row(type_1(F.OBJECT_ID, F.OBJECT_NAME));
END LOOP; return;end;--5.查询数据 SELECT * FROM TABLE(pipe_test);
create or replace type type_1 AS OBJECT(a number,b varchar2(200));
--2、为上一步定义的类型定义一个集合类型
CREATE TYPE t_1 AS TABLE OF type_1;
--3、创建表
create table t_obj as select * from dba_objects;--4、pipelined 函数
create or replace function pipe_test return t_1
PIPELINED ASbegin FOR F IN (select a.object_id, a.object_name from t_obj a) LOOP
pipe row(type_1(F.OBJECT_ID, F.OBJECT_NAME));
END LOOP; return;end;--5.查询数据
SELECT * FROM TABLE(pipe_test);