--In SQL/PL--

This is the previous assignment ---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. --

Assignment 4-10: Using a Different Form of Explicit Cursors Redo Assignment 4-9, but use a different cursor form to perform the same task.

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()