Question: THE CODE I MADE IS FOR PART A IT HAS AN ERROR CAN SOMEONE EXPLAIN THE ERROR TO ME ALSO IT HAS TO BE IN

 THE CODE I MADE IS FOR PART A IT HAS AN

THE CODE I MADE IS FOR PART A IT HAS AN ERROR CAN SOMEONE EXPLAIN THE ERROR TO ME ALSO IT HAS TO BE IN ORACLE APPLICATION EXPRESS. The question is the image below

ERROR CAN SOMEONE EXPLAIN THE ERROR TO ME ALSO IT HAS TO

delimiter // CREATE PROCEDURE GET_CREDIT LIMIT( IN I_CUST_ID CHAR(5)) BEGIN DECLARE I_CUSTOMER_NAME VARCHAR(41) DECLARE I CREDIT 1 IMII DECIMAL (7,2); SELECT CONCAT (FIRST NAME, ;, LAST_NAME) AS CUSTOMER_NAME, CREDIT LIMIT INTO I_CUSTOMER NAME, I_CREDIT_LIMIT FROM CUSTOMER WHERE CUST_ID = I CUST ID; SELECT I_CUSTOMER_NAME, I_CREDIT LIMII; END// delimiter; Results Explain Describe Saved SQL. History 0.01 seconds 5. Write MySQL, PL/SQL, or T-SQL procedures to accomplish the following tasks: a. Obtain the name and credit limit of the customer whose ID currently is stored in L_CUST_ID. Place these values in the variables L_CUSTOMER_MAME and L_CREDITUMMT, respectively. Output the contents of L_CUSTOMER_ MAME and L_CREDT_LMIT b. Ohtain the invoice date, customer ID, and first and last names for the invoice whose number currently is stored in LIMWOICE_NUM. Place these values in the variables LIINOICE_DATE, LCUST_ID, and L_CUST_MANE, respectively, Output the contents of LINVOICE_DATE, L_CUSTIID, and LCUST_MANE. c. Add a roiv to the INVOICE table. d. Change the date of the invoice whose number is stored in LINOICE_NUM to the date currently foundin LIINOICE_DATE. Delete the invoice whose number is stored in fluwoick wuM

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!