6 Replies Latest reply: Apr 30, 2013 6:02 PM by Yaniv Egozi RSS

    deployment of dates

    Yaniv Egozi

      G'day,

      I have a table that show payment_date, ammount, payment_number, first_payment_ammount, other_payments_ammount

      for example: payment_date  = 28-APR-2013, ammount = 1000, payment_number = 9,  first_payment_ammount = 200, other_payments_ammount = 100.

      I want to to see each payment with it's calculated payment_date.

       

      It's should look like this:

      28-APR-2013, 200, 1

      28-MAY-2013, 100, 2

      28-JUN-2013, 100, 3

      28-JUL-2013, 100, 4

      28-AUG-2013, 100, 5

      28-SEP-2013, 100, 6

      28-OCT-2013, 100, 7

      28-NOV-2013, 100, 8

      28-DEC-2013, 100, 9

       

      What's the best way to do it?

       

      Thanks in advance

      Yaniv