Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions