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...


MySQL


Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter).


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.



OWNER_NUM<br>LAST_NAME<br>FIRST_NAME<br>ADDRESS<br>CITY<br>STATE<br>ZIP_CODE<br>AK102<br>Aksoy<br>Ceyda<br>411 Griffin Rd.<br>Seattle<br>WA<br>98131<br>BI109<br>Bianchi<br>Nicole<br>7990 Willow Dr.<br>New York<br>NY<br>10005<br>BU106<br>Burke<br>Ernest<br>613 Old Pleasant St.<br>Twin Falls<br>ID<br>83303<br>CO103<br>Cole<br>Meerab<br>9486 Circle Ave.<br>Olympia<br>WA<br>98506<br>J0110<br>Jones<br>Ammarah<br>730 Military Ave.<br>Seattle<br>WA<br>98126<br>КО104<br>Kowalczyk<br>Jakub<br>7431 S. Bishop St.<br>Bellingham<br>WA<br>98226<br>LO108<br>Lopez<br>Janine<br>9856 Pumpkin Hill Ln.<br>Everett<br>WA<br>98213<br>МO100<br>Мoore<br>Elle-May<br>8006 W. Newport Ave.<br>Reno<br>NV<br>89508<br>

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

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here