Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Create a PL/SQL program to print a mailing label for the following customer information. (20 POINTS) curr_customer_first Neal curr_customer_last Graham curr_address 9815 Circle Dr
1. Create a PL/SQL program to print a mailing label for the following customer information. (20 POINTS) curr_customer_first Neal curr_customer_last Graham curr_address 9815 Circle Dr curr_city Tallahassee curr_state FL curr_zip 32308 3. Write program commands to declare the following variables and assign to them the given values: (20 POINTS) Variable Name Data Type Value inventory_ID Numeric inventory_color Character Sky Blue inventory_price Numeric 259.99 inventory_QOH Numeric Write commands that use the variables to display the output in the following format: Inventory ID: 5 Color: Sky Blue Price: $259.99 Quantity on Hand: 23 Do not insert, or hard-coed, the actual data values in the output procedure. 5. The management of Clearwater Traders is considering implementing a new discount policy. If the total order is more than $100, the customer receives a 10% discount; if it totals more than $200, a 20% discount is applied. Create a PL/SQL block that calculates the total amount due for each order before any discount is applied and then the revised amount due with the appropriate discount applied. Include only the order ID, original amount, and discounted amount in the results. (20 POINTS) Create a PL/SQL block that can be used to retrieve the description and price of an inventory item based on its item ID. Include the appropriate exception handling to display a message if the item is not found. (20 POINTS)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started