Question: Create anonymous block USING PL/SQL to retrieve and display data for all pledges made in a specified month. One row of output should be displayed
Create anonymous block USING PL/SQL to retrieve and display data for all pledges made in a specified month. One row of output should be displayed for each pledge. More specifically, each row include :
Pledge ID, donor ID, and pledge amount
If the pledge is being paid in a lump sum, display Lump Sum
If the pledge is being paid in monthly, display Monthly ** followed by number of months for payment.
t The list should be sorted to display all lump sum pledges first.
Here is data of table dd_pledge.

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
