Question: Consider the database table structure shown in the fizure, (a) Write a SELECT statement (compatible with an Oracle RDBMSl that calculates how much remains duc

 Consider the database table structure shown in the fizure, (a) Write

Consider the database table structure shown in the fizure, (a) Write a SELECT statement (compatible with an Oracle RDBMSl that calculates how much remains duc for cach invoice that has a positive amount due, How much remains due is tho invoice total less any payments less any credits. Write the query so that the columns in the result set are aliased with an appropriate meaningful name. (b) Then write two rows of sample data that might be retrieved by the query. What is actually retrieved depends on what is in the table. The data you write does not have to match any data that is actually in the sample tables and data that is provided with the Murach book. AP INVOICES Columns Deta l Constraints IGrants IStaistics ITrigpers IFlashiback Dependendes IDetails Partitions lindexes Isqu . Actions .. COLLIMN NAME 1 INVOICE ID VENDOR ID INVOICE NUMBER INVOICE_DATE INVOICE TOTAL PAYMENT TOTAL CREDIT TOTAL 8 TERMS ID 9 INVOICE 0 PAYMENT_DATE NULLABLE No No Yes DEFALLT NUMBER NUMBER VARCHAR2(50 BYTE) DATE NUMBER(92) NUMBER(9,2) NUMBER(92) NUMBER DATE DATE 1 (null) 2 (null) 3 (null) 5 (null) 6 (null) Yes 8 (null) DUE DATE (null) (null) Yes 10 (null)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!