Answered

Welcome to Westonci.ca, the Q&A platform where your questions are met with detailed answers from experienced experts. Explore in-depth answers to your questions from a knowledgeable community of experts across different fields. Discover detailed answers to your questions from a wide network of experts on our comprehensive 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 appreciate your visit. Hopefully, the answers you found were beneficial. Don't hesitate to come back for more information. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.