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

SELECT pledge_ID,

donor_ID,

pledge_amount,

total_paid,

pledge_amount - total paid

FROM pledges;

Step-by-step 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.