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.

Create anonymous block USING PL/SQL to retrieve and display data for all

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!