Question: 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 forthe following customer information. (20 POINTS) curr_customer_first Neal curr_customer_last Graham curr_address 9815Circle Dr curr_city Tallahassee curr_state FL curr_zip 32308 3. Write program commandsto declare the following variables and assign to them the given values:

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

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!