Crete a user defined function that determines the price markup in the products file. Be prepared to show it being used in a select statement in the select list, the where clause, and the order by clause. When demonstrating this just include the product name, the two different types of prices and the markup.

2. PATIENTA and INSURANCEA tables have been provided for you. Use those tables for your assignment Adapt your lab stored procedure to reject any updates where a company tries to pay 25% or less. 

Adapt your lab procedure to use a CURSOR that goes through all the updated rows after the update was applied and reports on the ones where the percentage payout by the company for all the patients exceeds the company's maximum payout amount.

For this assignment, we will not adjust the insurance payment to the maximum payout they allow, we will just report on it.
 

 

Transcribed Image Text:

Oracle SQL Developer : Winter 2023 ZE File Edit View Navigate Run Source Team Tools Window Help Cursor.sql x Welcome Page SOL Script Output x SOL Winter 2023 ZE * Worksheet Query Builder 1 SET SERVEROUTPUT ON; 2 EXECUTE INPAYS (888, 22); 1 Task completed in 0.104 seconds Invalid rate of %22 attempted No updates applied for Cut Rate Insurers Resubmit with a rate higher than 25% ! Winter 2023 ZE 0 PL/SQL procedure successfully completed. Statements - Log Messages Luyymny raye Statements Error(50,4): PLS-00103: Encountered the symbol "DBMS_OUTPUT" when expecting one of the following: X : . (%; The symbol Oracle SQL Developer : Winter 2023 ZE File Edit View Navigate Run Source Team Tools Window Help Cursor.sql x Welcome Page SOL Script Output x SOL Winter 2023 ZE * Worksheet Query Builder 1 SET SERVEROUTPUT ON; 2 EXECUTE INPAYS (888, 22); 1 Task completed in 0.104 seconds Invalid rate of %22 attempted No updates applied for Cut Rate Insurers Resubmit with a rate higher than 25% ! Winter 2023 ZE 0 PL/SQL procedure successfully completed. Statements - Log Messages Luyymny raye Statements Error(50,4): PLS-00103: Encountered the symbol "DBMS_OUTPUT" when expecting one of the following: X : . (%; The symbol