Answered

Find the best solutions to your questions at Westonci.ca, the premier Q&A platform with a community of knowledgeable experts. Get immediate and reliable solutions to your questions from a knowledgeable community of professionals on our platform. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform.

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

Sagot :

Emela

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.

We hope our answers were helpful. Return anytime for more information and answers to any other questions you may have. We appreciate your visit. Our platform is always here to offer accurate and reliable answers. Return anytime. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.