Question: Create PL/SQL block using a CASE statement. It needs to determine the rating and then display the results on screen. the code rates the customer

Create PL/SQL block using a CASE statement. It needs to determine

Create PL/SQL block using a CASE statement. It needs to determine the rating and then display the results on screen. the code rates the customer "High" if total purchases are greater than $200, "Mid" if greater than $100, and "Low" if $100 or lower. Use a scalar variable for the total purchase amount and initialize this variable to different values to test your block

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!

ASSIGNMENT #2 SECTION A Using Scalar Variables Create a PL/SQL block containing the following variables : NAME DATA TYPE OPTION INITIAL VALUE lv_test_date DATE December 10, 2012 lv_test_num NUMBER...

--Only want answer to Question 2-4(question 2-2 is needed to answer 2-4)-- This needs to be in PL/SQL Assignment 2-2: Creating a Flowchart The Brewbeans application needs a block that determines...

--Only want answer to Question 2-4(question 2-2 is needed to answer 2-4)-- Assignment 2-2: Creating a Flowchart The Brewbeans application needs a block that determines whether a customer is rated...

Question 1) Use Brewbean database for this question. Script to build sample DB is given in the same Mid Term folder Working with IF Statements Brewbeans calculates shipping cost based on the quantity...

Using Searched CASE Statements The Brewbeans application needs a block to determine whether a customer is rated HIGH, MID, or LOW based on his or her total purchases. The block needs to select the...

Based on this textbook: https://www.chegg.com/homework-help/using-searched-case-statements-brewbean-s-application-needs-chapter-3-problem-4hap-solution-9781133947363-exc Problem Using Searched CASE...

Based on this textbook problem from here: https://www.chegg.com/homework-help/processing-database-data-statements-brewbean-s-application-n-chapter-3-problem-3hap-solution-9781133947363-exc Processing...

Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

i need 5 balance sheets for Auto Zone company from the resources "attachments and the link below" for the last 5 years, 2011-2012-2013-2014-2015 with the sixth page including the total income and...

USE VIRTUAL WORK METHOD EI = CONSTANT 71.1 kN 4.11 kN/m Im D I.Sm A 3m B 2m 1.1 Kum DETERMINE THE FOLLOWING: Slope at A (radians) Slope at E (radians) Deflection at A (mm) Deflection at B (mm) Change...

In each case, identify the relevant sampling distribution (if possible), and justify your answer. (a) House prices have a positively-skewed distribution. Suppose Perth house values have a mean price...

2 . a . In Note 1 4 , which depreciation method does Target use for property and equipment for financial reporting? b . In Note 1 4 , which depreciation method is used for tax purposes? c . Which...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

9-16 How did WIM manage the change from a local MRP system to Epicors ERP system? Welding Industries Malaysia (WIM) is the only local Malasian company that manufactures welding machines for...

9-15 How has Epicors ERP system helped WIM to make its production process more efficient? Welding Industries Malaysia (WIM) is the only local Malasian company that manufactures welding machines for...

9-12 In MyMISLab, you will find a Collaboration and Teamwork Project dealing with the concepts in this chapter. You will be able to use Google Drive, Google Docs, Google Sites, Google+, or other...