write two procedures for this table with exception and the use of cursors

1.:a procedure with Cust_ID, Cust_name, Cust_email, Cust_street_address, Cust_city, Cust_state, Cust_Zip, Cust_Credit_Card and a cursor to store the select statement output into the cursor Output: Creates a new row in the Customer table and displays the values with the cursor

2. List names of all customers living in a given zip code. Input:  a procedure with Cust_name, Cust_Zip and a cursor to store the select statement output into the cursor. Output: Displays a list of all the customer names for a specific zip code with the cursor.

Transcribed Image Text:

PR Worksheet Query Builder * D / H 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) ); Script Output X 1.04900002 seconds IS420 PR Worksheet Query Builder * D / H 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) ); Script Output X 1.04900002 seconds IS420