Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help me write 2 procedures for this table using cursors and exception in the procedures 3. names of customers who spent the most

can you help me write 2 procedures for this table using cursors and exception in the procedures

image

3. names of customers who spent the most money. Input:  a function with Cust_Name, Amount_Paid, Tip, Cust_Credit_Card, Cust_email (join) followed by a procedure and a cursor to store the select statement output into the cursor. Output: Displays the 3 names of customers with the highest amount_paid and 3 names of customers with the lowest amount_paid using the cursor.

4. Report list of states based on customers who tip generously. Input:  a function with Cust_state, Tip, MAX(), DESC() followed by a procedure and a cursor to store the select statement output into the cursor.


PR Worksheet Query Builder * D / H Script Output X 1.04900002 seconds CREATE TABLE Customers ( Cust_ID NUMBER NOT NULL, Cust_Name VARCHAR2 (50) NOT NULL, Cust Email VARCHAR2 (50) NOT NULL, Cust_Street_Address VARCHAR2 (70) NOT NULL, Cust_City VARCHAR2 (50) NOT NULL, Cust_State VARCHAR2 (20) NOT NULL, Cust_Zip NUMBER NOT NULL, Cust_Credit Card_Num NUMBER NOT NULL, CONSTRAINT Customers_pk PRIMARY KEY (Cust_ID) ); IS420

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_2

Step: 3

blur-text-image_3

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

Introduction to Managerial Accounting

Authors: Peter C. Brewer, Ray H. Garrison, Eric Noreen, Suresh Kalagnanam, Ganesh Vaidyanathan

5th Canadian edition

77429494, 1259105709, 1260480798, 978-1259105708

More Books

Students also viewed these Databases questions

Question

What is the Easterlin Paradox?

Answered: 1 week ago