Oracle PL/SQL/System Packages/dbms scheduler

dbms_scheduler.evaluate_calendar_string

   <source lang="sql">

SQL> SQL> DECLARE

 2     l_start_date    TIMESTAMP;
 3     l_next_date     TIMESTAMP;
 4     l_return_date   TIMESTAMP;
 5  BEGIN
 6     l_start_date := TRUNC (SYSTIMESTAMP);
 7     l_return_date := l_start_date;
 8     FOR ctr IN 1 .. 10
 9     LOOP
10        dbms_scheduler.evaluate_calendar_string
11                         ("FREQ=MONTHLY;INTERVAL=2",
12                          l_start_date,
13                          l_return_date,
14                          l_next_date
15                         );
16        DBMS_OUTPUT.put_line ("Next Run on: "|| TO_CHAR (l_next_date, "mm/dd/yyyy hh24:mi:ss"));
17        l_return_date := l_next_date;
18     END LOOP;
19  END;
20  /

PL/SQL procedure successfully completed. SQL> SQL>

</source>