Description
- Write a stored procedure that get an integer number and prints information on whether the number is even or odd. (look at it being divisible by 2)
- You have the PRODUCTS, ORDERS, ORDERDETAIL and CUSTOMERS tables already loaded. Provide a procedure that takes an order number and provides information about the order as shown below. Handle exceptions for this.
- Copy the script that produces the tables PATIENT4 AND INSURANCE4. We will create a procedure that applies a percentage of the charge according to what the insurance company rate is included.
This is how your SQL procedure will run:
If we check the PATIENT4 table the previously null values will show the 85% rate has been applied with the INSUREPAYS column entry.
