ORACLE管道函数

CREATE OR REPLACE TYPE TEMP_ROW AS OBJECT(NAME VARCHAR2(10))--创建行对象
CREATE OR REPLACE TYPE TEMP_TYPE AS TABLE OF TMPE_ROW;--创建表对象

CREATE OR REPLACE FUNCTION TEMP_FUN(IN_SOMETHING IN VARCHAR2) --函数
 RETURN TEMP_TYPE
  PIPELINED AS
  ONEROW TMPE_ROW;
BEGIN
  FOR CURROW IN (SELECT IN_SOMETHING FROM DUAL) LOOP
    ONEROW := TMPE_ROW(CURROW.IN_SOMETHING);
    PIPE ROW(ONEROW);
  END LOOP;
  RETURN;
END;

SELECT * FROM TABLE(TEMP_FUN('AAA'));--调用函数

CREATE OR REPLACE TYPE TEMP_ROW AS OBJECT(NAME VARCHAR2(10))--创建行对象
CREATE OR REPLACE TYPE TEMP_TYPE AS TABLE OF TMPE_ROW;--创建表对象

CREATE OR REPLACE FUNCTION TEMP_FUN(IN_SOMETHING IN VARCHAR2) --函数
 RETURN TEMP_TYPE
  PIPELINED AS
  ONEROW TMPE_ROW;
BEGIN
  FOR CURROW IN (SELECT IN_SOMETHING FROM DUAL) LOOP
    ONEROW := TMPE_ROW(CURROW.IN_SOMETHING);
    PIPE ROW(ONEROW);
  END LOOP;
  RETURN;
END;

SELECT * FROM TABLE(TEMP_FUN('AAA'));--调用函数

CREATE OR REPLACE TYPE TEMP_ROW AS OBJECT(NAME VARCHAR2(10))--创建行对象
CREATE OR REPLACE TYPE TEMP_TYPE AS TABLE OF TMPE_ROW;--创建表对象

CREATE OR REPLACE FUNCTION TEMP_FUN(IN_SOMETHING IN VARCHAR2) --函数
 RETURN TEMP_TYPE
  PIPELINED AS
  ONEROW TMPE_ROW;
BEGIN
  ONEROW := TMPE_ROW(IN_SOMETHING);
  PIPE ROW(ONEROW);
  RETURN;
END;

SELECT * FROM TABLE(TEMP_FUN('AAA'));--调用函数