--创建类型
CREATE OR REPLACE TYPE MSGTYPE AS TABLE OF VARCHAR2(4000);
--详见创建类型图
--创建函数
CREATE OR REPLACE FUNCTION DISPLAY(V_COUNT IN INTEGER) RETURN MSGTYPE
PIPELINED AS
BEGIN
FOR X IN 1 .. V_COUNT LOOP
PIPE ROW(X);
--DBMS_LOCK.SLEEP(1);
END LOOP;
END;
--调用函数
SELECT * FROM TABLE(DISPLAY(10));
运行结果 图: