PROJECT $\backslash$#$3$: CREATE THE FOLLOWING STORED PROCEDURE

THAT WILL DISPLAY A CUSTOMER.

First, we declare variables to store customer ID$,$ customer name, and email. Then, we retrieve customer information using a SELECT statement into the respective variables. The SELECT statement has a WHERE clause to filter based on a specific customer ID$.$ You can replace $123$ with the desired customer ID$.$

Next, we display the retrieved customer information using DBMS$\_$OUTPUT.PUT$\_$LINE statements.

After that, we update the email address for the customer using an UPDATE statement. You can modify vemail with the new email address you want to set.

Then, we retrieve the updated customer information again and display it using DBMS$\_$OUTPUT.PUT$\_$LINE statements.

$```$

CREATE OR REPLACE PROCEDURE GetCustomerInfo

IS

$--$ Declare variables to store customer details

v$\_$CustomerID Customers.CustomerID$\%$TYPE;

v$\_$CustomerName Customers.CustomerName$\%$TYPE;

v$\_$Email Customers.Email$\%$TYPE;

BEGIN

$--$ Retrieve customer information

SELECT

CustomerID,

CustomerName,

Email

INTO

v$\_$CustomerID,

v$\_$CustomerName,

v$\_$Email

FROM

Customers

WHERE

CustomerID $=1$; $--$ Specify the desired customer ID

$--$ Display customer information

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Customer ID: $"||$ v$\_$CustomerID$)$;

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Customer Name: $\text{'}||$ v$\_$CustomerName$)$;

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Email: $\text{'}||$ v$\_$Email$)$;

END;

$/$

$```$

THEN EXECUTE THE STORED PROCEDURE

BEGIN

GetcustomerInfo;

END;

$/$