Answered

Westonci.ca connects you with experts who provide insightful answers to your questions. Join us today and start learning! Explore a wealth of knowledge from professionals across various disciplines on our comprehensive Q&A 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.

Thanks for using our service. We aim to provide the most accurate answers for all your queries. Visit us again for more insights. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. We're dedicated to helping you find the answers you need at Westonci.ca. Don't hesitate to return for more.