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

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
Get step-by-step solutions from verified subject matter experts
