Task 5: Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter). 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_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME
Task 5: Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter). 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_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 3EYK
Related questions
Question
Task 5: Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter).
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_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME.
![PROPERTY_ID
OFFICE_NUM
ADDRESS
SQR_FT
BDRMS
FLOORS
MONTHLY_RENT
OWNER_NUM
1
1
30 West Thomas Rd.
1600
3
1
1400
BU106
2
1
782 Queen Ln.
2100
4
2
1900
AK102
3
1
9800 Sunbeam Ave.
1005
2
1
1200
BI109
4
1
105 North Illinois Rd.
1750
3
1
1650
кО104
5
1
887 Vine Rd.
1125
2
1
1160
S1105
6
1
8 Laurel Dr.
2125
4
2
2050
MO100
7
2
447 Goldfield St.
1675
3
2
1700
Co103
8
2
594 Leatherwood Dr.
2700
2
2750
ко104
2
504 Windsor Ave.
700
2
1050
PA101
10
891 Alton Dr.
1300
3
1
1600
LO108
11
9531 Sherwood Rd.
1075
2
1
1100
J0110
12
2
2 Bow Ridge Ave.
1400
3
2
1700
RE107](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0985f779-e099-4707-8f72-7eb4444fa04d%2F89990942-af14-41c7-a221-ee8ce308cd9b%2F9nk7yvc_processed.png&w=3840&q=75)
Transcribed Image Text:PROPERTY_ID
OFFICE_NUM
ADDRESS
SQR_FT
BDRMS
FLOORS
MONTHLY_RENT
OWNER_NUM
1
1
30 West Thomas Rd.
1600
3
1
1400
BU106
2
1
782 Queen Ln.
2100
4
2
1900
AK102
3
1
9800 Sunbeam Ave.
1005
2
1
1200
BI109
4
1
105 North Illinois Rd.
1750
3
1
1650
кО104
5
1
887 Vine Rd.
1125
2
1
1160
S1105
6
1
8 Laurel Dr.
2125
4
2
2050
MO100
7
2
447 Goldfield St.
1675
3
2
1700
Co103
8
2
594 Leatherwood Dr.
2700
2
2750
ко104
2
504 Windsor Ave.
700
2
1050
PA101
10
891 Alton Dr.
1300
3
1
1600
LO108
11
9531 Sherwood Rd.
1075
2
1
1100
J0110
12
2
2 Bow Ridge Ave.
1400
3
2
1700
RE107
![OWNER_NUM
LAST_NAME
FIRST_NAME
ADDRESS
CITY
STATE
ZIP_CODE
AK102
Aksoy
Ceyda
411 Griffin Rd.
Seattle
WA
98131
BI109
Bianchi
Nicole
7990 Willow Dr.
New York
NY
10005
BU106
Burke
Ernest
613 Old Pleasant St.
Twin Falls
ID
83303
CO103
Cole
Meerab
9486 Circle Ave.
Olympia
WA
98506
J0110
Jones
Ammarah
730 Military Ave.
Seattle
WA
98126
KO104
Kowalczyk
Jakub
7431 S. Bishop St.
Bellingham
WA
98226
LO108
Lopez
Janine
9856 Pumpkin Hill Ln.
Everett
WA
98213
MO100
Мoore
Elle-May
8006 W. Newport Ave.
Reno
NV
89508
PA101
Patel
Makesh
7337 Sheffield St.
Seattle
WA
98119
RE107
Redman
Seth
7681 Fordham St.
Seattle
WA
98119
S1105
Sims
Haydon
527 Primrose Rd.
Portland
OR
97203](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0985f779-e099-4707-8f72-7eb4444fa04d%2F89990942-af14-41c7-a221-ee8ce308cd9b%2Fwswijq_processed.png&w=3840&q=75)
Transcribed Image Text:OWNER_NUM
LAST_NAME
FIRST_NAME
ADDRESS
CITY
STATE
ZIP_CODE
AK102
Aksoy
Ceyda
411 Griffin Rd.
Seattle
WA
98131
BI109
Bianchi
Nicole
7990 Willow Dr.
New York
NY
10005
BU106
Burke
Ernest
613 Old Pleasant St.
Twin Falls
ID
83303
CO103
Cole
Meerab
9486 Circle Ave.
Olympia
WA
98506
J0110
Jones
Ammarah
730 Military Ave.
Seattle
WA
98126
KO104
Kowalczyk
Jakub
7431 S. Bishop St.
Bellingham
WA
98226
LO108
Lopez
Janine
9856 Pumpkin Hill Ln.
Everett
WA
98213
MO100
Мoore
Elle-May
8006 W. Newport Ave.
Reno
NV
89508
PA101
Patel
Makesh
7337 Sheffield St.
Seattle
WA
98119
RE107
Redman
Seth
7681 Fordham St.
Seattle
WA
98119
S1105
Sims
Haydon
527 Primrose Rd.
Portland
OR
97203
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
From the same tables above and question, need the awnser in mysql instead
Solution
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr