Advertisement
Guest User

Untitled

a guest
May 6th, 2015
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. create table maint_sched (maint_id number, start_date date, day_interval number);
  2. insert into maint_sched values (1, date '2015-01-01', 90);
  3. insert into maint_sched values (2, date '2015-04-01', 200);
  4. insert into maint_sched values (3, date '2015-07-01', 30);
  5.  
  6. MAINT_ID DATE_DUE
  7. -------- ---------
  8. 1 1-Jan-15
  9. 1 1-Apr-15
  10. 2 1-Apr-15
  11. 1 30-Jun-15
  12. 3 1-Jul-15
  13. 3 31-Jul-15
  14. 3 30-Aug-15
  15. 1 28-Sep-15
  16. 3 29-Sep-15
  17. 2 18-Oct-15
  18. 3 29-Oct-15
  19. 3 28-Nov-15
  20. 1 27-Dec-15
  21. 3 28-Dec-15
  22.  
  23. -- This generates a list of every five days for 36 months
  24. SELECT (sysdate + (5 * level)) AS duedate
  25. FROM dual
  26. CONNECT BY (sysdate + (5 * level)) < add_months(sysdate, 36)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement