(Solved) Create a PL/SQL block to retrieve and display data for all pledges made in a specified month. One row of output should be displayed for each pledge....

Create a PL/SQL block to retrieve and display data for all pledges made in a specified month. One row of output should be displayed for each pledge. Include the following in each row of output: • 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 payments, display “Monthly - #” (with the # representing the number of months for payment). • The list should be sorted to display all lump sum pledges first.

Use only the following for declarations:

  TYPE type_pledge IS TABLE OF dd_pledge%ROWTYPE
       INDEX BY PLS_INTEGER;
  tbl_pledge type_pledge;
  lv_mth_txt VARCHAR(7) := '10/2012';
  lv_pay_txt VARCHAR2(15);

Hint: Review BULK COLLECT and use the ORDER BY clause of the SELECT statement to sort. To handle the characters for month and year, which I provided above, getting only those matching from the database, use this clause in your SELECT statement:

WHERE TO_CHAR(pledgedate,'MM/YYYY') = lv_mth_txt

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Mar 27, 2022

PRICE: $18

Solution~000200058893.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Mar 27, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Order-Now