Question

create a pl/SQL block to retieve and display information for a specific pledge. Display the pledge ID, donor ID, Pledge Amount, total paid so far and the difference between the pledge amount and total paid amount

Answer 1

Answer:

SELECT pledge_ID,

             donor_ID,

              pledge_amount,

              total_paid,

              pledge_amount - total paid

   FROM pledges;

Explanation:

The SELECT statement initiates the display command. It states the variables to be selected.

The variables are usually separated by a comma.

The FROM statement indicates the location from which the variables ne selected from.

; signifies the end of the query, stating that the query should be run.