CREATE OR REPLACE TYPEmyObjectFormat
AS OBJECT
( A INT,
B DATE,
C VARCHAR2(25)
);
CREATE OR REPLACE TYPE myTableType AS TABLE OFmyObjectFormat;
create or replace FUNCTION prodFuncs RETURN myTableType PIPELINED as
--type myTableType AS TABLE OF myObjectFormat;
BEGIN
FOR i in 1 .. 5 LOOP
PIPE ROW (myObjectFormat(i,SYSDATE+i,'Row '||i));
END LOOP;
RETURN;
END;
/
--查看使用
SELECT * FROM TABLE(prodFuncs());
作者“Clement Ge 的专栏”