Question: Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner whose number currently is
Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner whose number currently is stored in 1_OWNER_NUM. Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM,I_FIRST_NAME, and I_LAST_NAME. b. Obtain the office number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID. Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_PROPERTY_ID, I_ADDRESS, I_OWNER_NEM, 1_FIRST_NAME, and I_LAST NAME. c. Add a row to the OWNER table. d. Change the last name of the owner whose number is stored in I_OWNER_NUM to the value currently found in I_LAST_NAME
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
