Write PL/SQL

a. Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_GUIDE_NUM, I_FIRST_NAME, and I_LAST_NAME.

b. Obtain the number of persons, customer number, and customer last name for every reservation whose ID currently is stored in I_RESERVATION_ID. Place these values in the variables I_NUM_PERSONS, I_CUSTOMER_NUM and I_ LAST_NAME, respectively. Output the contents of I_NUM_PERSONS, I_CUSTOMER_NUM and I_LAST_NAME.

c. Add a row to the GUIDE table.

d. Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME.

e. Delete the guide whose number is stored in I_GUIDE_NUM.