Table structure of table 'table_name'

Function example

 FUNCTION function_name (p_date_from     IN DATE)
      RETURN SYS_REFCURSOR
   AS
      c_data   SYS_REFCURSOR;
      v_date_from        DATE;
   BEGIN
      OPEN c_data FOR
        SELECT ROWNUM AS sl, * 
        FROM table_name  
        WHERE created_at between trunc(p_date_from) and sysdate;
      RETURN c_data;
      CLOSE c_data;
   END function_name;;

Referances

• oracletutorial.com