CREATE OR REPLACE TYPE MY_OBJECT  
AS OBJECT 
( 
  A   INT, 
  B   DATE, 
  C   VARCHAR2(25) 
);

CREATE OR REPLACE TYPE MY_TAB 
   AS TABLE OF MY_OBJECT;

CREATE OR REPLACE FUNCTION MY_FUNC (ST_DATE DATE) RETURN MY_TAB PIPELINED IS 
BEGIN 
  FOR i in 1 .. 5 
    LOOP 
      PIPE ROW (MY_OBJECT(i,ST_DATE+i,'Row '||i)); 
    END LOOP; 
    RETURN; 
  END;

SELECT * FROM TABLE(MY_FUNC(SYSDATE))

CREATE TABLE SOURCE_DATA (ID NUMBER, ST_DATE DATE)

INSERT INTO SOURCE_DATA VALUES (1,SYSDATE-7)

INSERT INTO SOURCE_DATA VALUES (2,SYSDATE-6)

INSERT INTO SOURCE_DATA VALUES (3,SYSDATE-5)

INSERT INTO SOURCE_DATA VALUES (4,SYSDATE-4)

INSERT INTO SOURCE_DATA VALUES (5,SYSDATE-3)

INSERT INTO SOURCE_DATA VALUES (6,SYSDATE-2)

INSERT INTO SOURCE_DATA VALUES (7,SYSDATE-1)

INSERT INTO SOURCE_DATA VALUES (8,SYSDATE)

SELECT * FROM SOURCE_DATA ORDER BY 1