--Using SQL/PL--

Assignment 4-9: Using an Explicit Cursor 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.

dd-donor dd pledge dd payment dd dana IDDONOR NOT NULL NUMBERI4) FIRSTNAME VARCHAR2(15 dd project dd status FIGURE 1-9 The DoGood Donor database ERD STATE VARCHAR2(10) NULL NUMBER(6) VARCHAR2(60 PROISTARTDATE IDPAY NOT NULL NUMBER(6) Name Null? IDPLEDGE NOT NULL NUMBER(S NULL NUMBERI2) VARCHAR215) NUMBER3 FIRSTPLEDGE CHAR() dd-donor dd pledge dd payment dd dana IDDONOR NOT NULL NUMBERI4) FIRSTNAME VARCHAR2(15 dd project dd status FIGURE 1-9 The DoGood Donor database ERD STATE VARCHAR2(10) NULL NUMBER(6) VARCHAR2(60 PROISTARTDATE IDPAY NOT NULL NUMBER(6) Name Null? IDPLEDGE NOT NULL NUMBER(S NULL NUMBERI2) VARCHAR215) NUMBER3 FIRSTPLEDGE CHAR()