Question: 4. Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner who'se number currently

 4. Write PL/SQL or T-SQL procedures to accomplish the following tasks:

4. Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner who'se number currently is stored in 1_OWNER_NUM. Place the be values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, L_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 variablesI_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and 1_LAST_NAME, respectively. Output the contents of I_PROPERTY_ID, I_ADDRESS, I_OWNER NUM, I 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 1_OWNER_NUM to the value currently found in 1 LAST NAME

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!