Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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: 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started