Need questions 1 and 2 answered free of syntax errors if possible. 1. need a procedure named
Question:
Need questions 1 and 2 answered free of syntax errors if possible.
1. need a procedure named as "GET_CUSTOMER_ADDR" to obtain the whole customer address including Address, City, State & Zip of the customer whose customerID currently is stored in I_CUST_ID. Place the whole customer address in the variable named I_CUST_ADDR. Output the contents of I_CUST_ADDR.
If the input customerID does not exist in the database, display "No such a customer ID: " followed by the customerID. For example, if you try to get the whole customer address of the customer with customerID "125", the result should be "No such a customer ID: 125"."
2. Run your created procedure "GET_CUSTOMER_ADDR" and get the whole address of the two customers: the first customerID is 120, and the second customerID is 230.
3. need a statement that makes sure any customerID entered in ORDERS table also exists in the CUSTOMERS table.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill