oracle之function

CREATE OR REPLACE FUNCTION SELECT_CURSTARTANDEND(SELECTDATE  IN DATE)
  RETURN RESULT_T_CURSTARTANDEND
  PIPELINED IS




BEGIN
  PIPE ROW(RESULT_CURSTARTANDEND(
 trunc(SELECTDATE,'mm') ,
 trunc(add_months(SELECTDATE,1),'mm'),
   trunc(SELECTDATE,'mm')
  ));




  RETURN;

END SELECT_CURSTARTANDEND;

SELECT * FROM TABLE(SELECT_CURSTARTANDEND(SYSDATE))