Answer to Question #309952 in Databases | SQL | Oracle | MS Access for Simu

Question

Create a PL/SQL block that determines the total number of bookings made by the specific guest. The block must prompt the user to enter a staff number to retrieve and display this guest information as detailed in the output. Any guest with no cell number uses this number “012 5680-000”.

SQL> /

Enter value for guest_number: 1001 The Guest : MALHERBE(4510074554897) from Germiston who made total number of 4 bookings can be contacted on 071 3562-332

PL/SQL procedure successfully completed.

SQL> /

Enter value for guest_number: 1002 The Guest : NKOSI(7502210056087) from eMALAHLENI who made total number of 7 bookings can be contacted on 012 5680-000

PL/SQL procedure successfully completed.

SQL> /

Enter value for guest_number: 1003 The Guest : MAKHWATSHWA(9110236744589) from Mbombela who made total number of 2 bookings can be contacted on 084 5678-998

PL/SQL procedure successfully completed.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order