Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis In Microsoft Excel

Authors: Alex Holloway

1st Edition

B0CCCPKTTX, 979-8852388452

More Books

Students also viewed these Databases questions