SQL Database Write PL/SQL or T-SQL procedures to accomplish the following tasks: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. 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.Add a row to the GUIDE table.Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME.Delete the guide whose number is stored in I_GUIDE_NUM

Note: As per our company guidelines we are supposed to answer only first 3 sub-parts. Kindly repost…

Answered: SQL Database Write PL/SQL or T-SQL…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

Related questions

Question

SQL Database

Write PL/SQL or T-SQL procedures to accomplish the following tasks:

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.
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.
Add a row to the GUIDE table.
Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME.
Delete the guide whose number is stored in I_GUIDE_NUM

Expert Solution