Question: 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

PR Worksheet Query Builder * D / H Script Output X 1.04900002

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

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!