Using PL sql make the following query:

Total Services Income Report: Given a hotelID, calculate and display income from all services in all reservations in that hotel.

Sample is as follows :

CREATE OR REPLACE PROCEDURE SellHotel (In_HotelID IN Number) IS

HotelID HotelsProj.Hotel_ID%type;

HotelName HotelsProj.Hotel_Name%type;

HotelStatus HotelsProj.Hotel_Status%type;

BEGIN

Select Hotel_ID, Hotel_Name, Hotel_Status INTO HotelID,HotelName,HotelStatus From HotelsProj WHERE Hotel_ID = In_HotelID;

If HotelStatus = 'Sold' THEN

Dbms_Output.Put_Line('Hotel has already been sold');

Else

Update HotelsProj

Set Hotel_Status = 'Sold'

WHERE Hotel_ID = In_HotelID;

Dbms_Output.Put_Line('Hotel ' || HotelName || ' with Hotel ID ' || HotelID || ' has been sold.');

End If;

EXCEPTION

When No_Data_Found Then

Dbms_output.put_line('This hotel does not exist');

END;