Payment schedule for donors pledge

Query one: Create a pl/sql block using for loop to generate a payment schedule for a donors pledge, which is to be paid monthly in equal increments. Values available for the block are starting payment due date, monthly payment amount and number of totally monthly payments for the pledge. the list that is generated should display a line for each monthly payment showing payment number, date due, payment amount and donation balance (remaining amount of pledge owned). query two: accomplish the task in step on by using a while loop instead of displaying the donation balance on each line of output, display the total paid to date. **Initialize your own values, there is no table to pull data from**