Oracle 11g: PL/SQL Programming
Create a block to retrieve and display pledge and payment information for a specific donor. For
each pledge payment from the donor, display the pledge ID, pledge amount, number of monthly
payments, payment date, and payment amount. The list should be sorted by pledge ID and then
by payment date. For the first payment made for each pledge, display “first payment” on that
output row.