Oracle 11g: PL/SQL Programming Create a block to retrieve and display pledge and payment information for a specific donor.

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.