i have a questions on page118 from Murach\'s Oracle SQL and PL/SQL Works with Al
ID: 3529705 • Letter: I
Question
i have a questions on page118 from Murach's Oracle SQL and PL/SQL Works with All Versions Through 11g could write a code for me please. 9. write a SELECT statemnet that returns the balance due and the payment date from the invoices table, but only when the payment_date column contains a null value. then, modify the WHERE clause so it returns any invalid rows ( rows in which the balance due is zero and th payment date is null) 10. use the dual table to create a row with these columns: Starting Principal : Starting principle which should be equal to $51,000 New principal : starting principal plus a 10% increase interest : 6.5% of the new principal Principal + interest : the new principal plue the interest (add the expression you used for the new principal calculation to the expression you used for the interest calculation) 11. NOW, add a colum named "ststem date" that uses the TO_CHAR function to show the results of the SYSDATE function when its displayed with this format: 'dd-mon-yyy hh24 :mi: ss' i need seperate codes for each question thank youExplanation / Answer
bELOW IS WHAT YOU WANT , PLEASE RATE.
=======================================================
9) A) SELECT BALANCE_DUE,PAYMENT_DATE FROM INVOICES WHERE PAYMENT_DATE=NULL
B) SELECT BALANCE_DUE,PAYMENT_DATE FROM INVOICES WHERE BALANCE_DUE=0 AND PAYMENT_DATE=NULL
---------------------------------------------------------------------------------------------------
10) SELECT 51000 AS STARTING_PRINCIPAL,
51000+(0.1*51000) AS NEW_PRINCIPAL,
0.065* NEW_PRINCIPAL AS INTEREST,
NEW_PRINCIPAL+INTEREST AS INTEREST_CALCULATION
FROM Dual
---------------------------------------------------------------------------------------
11) SELECT 51000 AS STARTING_PRINCIPAL,
51000+(0.1*51000) AS NEW_PRINCIPAL,
0.065* NEW_PRINCIPAL AS INTEREST,
NEW_PRINCIPAL+INTEREST AS INTEREST_CALCULATION
TO_CHAR(SYSDATE,'dd-mon-yyyy hh24:mi:ss') AS SYSTEM_DATE
FROM Dual
-----------------------------------------------------------------------
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.