Can you please give me an example for recursive function in plsql

Which takes i_date as an input variable

using this i_date it should perform operations like it should fetch data from table into cursor


From this cursor I should insert data into a file .This file should be generated seperately for date that is passed in as input

Let us take that my input date is 01012016 the function should recursively perform until it reaches 31122016 (for every last day of a month i.e total 12 times)

SQL> create or replace
  2  function factorial (
  3    n positive
  4  ) return positive
  5  is
  6  begin
  7    if n = 1 then
  8      return n;
  9    else
 10    return n * factorial(n-1);
 11    end if;
 12  end;
 13  /

Function created.

SQL>
SQL> set serverout on
SQL> begin
  2    for i in 1..5 loop
  3      dbms_output.put_line(i || '! = ' || factorial(i));
  4    end loop;
  5  end;
  6  /
1! = 1
2! = 2
3! = 6
4! = 24
5! = 120

PL/SQL procedure successfully completed.