--创建类型
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));

运行结果 图: