Hi there I need to create a script to highlighting any bookings recorded for a given date by entering the date from the keyboard.

So far I've come up with the code below but I'm still unsure on how to get it work , any suggestions?

SELECT Name, Phonenumber, Date_of_Arrival
TO_CHAR('Date_of_Arrival, Date) "Input any Date:"
From booking
Order by Date_of_Arrival;

thx.

SELECT Name, Phonenumber, Date_of_Arrival
FROM booking
WHERE Date_of_Arrival = '&Input_any_date'
ORDER BY Date_of_Arrival;

Parameter "Input_any_date" should be entered in default date format. If you'd like to change it, change it to (for example)
WHERE Date_of_Arrival = TO_DATE('&Input_any_date', 'dd.mm.yyyy.')

By the way, "ORDER BY date_of_arrival" doesn't have much sense here as this query returns data for just one date.