MySQL
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
Extracted text: PROPERTY_ID OFFICE_NUM ADDRESS SQR_FT BDRMS FLOORS MONTHLY_RENT OWNER_NUM 1 1 30 West Thomas Rd. 1600 3 1 NULL BU106 2 1 782 Queen Ln. 2100 4 NULL AK102 3 1 9800 Sunbeam Ave. 1005 2 1 NULL BI109 4 1 105 North Illinois Rd. 1750 1 NULL KO104 5 1 887 Vine Rd. 1125 2 NULL SI105 6. 1 8 Laurel Dr. 2125 2 NULL М0100 7 447 Goldfield St. 1675 NULL CO103 8. 594 Leatherwood Dr. 2700 2 NULL К0104 1, 3.
Extracted 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 КО104 Kowalczyk Jakub 7431 S. Bishop St. Bellingham WA 98226 LO108 Lopez Janine 9856 Pumpkin Hill Ln. Everett WA 98213 МO100 Мoore Elle-May 8006 W. Newport Ave. Reno NV 89508