Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

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

Recommended Textbook for

Big Data, Mining, And Analytics Components Of Strategic Decision Making

Authors: Stephan Kudyba

1st Edition

1466568704, 9781466568709

More Books

Students also viewed these Databases questions

Question

=+Describe an important trade-off you recently faced

Answered: 1 week ago