Certainly,

I have a table called 'orders' and I need to run a query to product an output of all the orders that were placed on a specific date.

This is how far Ive got...:-
undef vday
undef vname

DECLARE
vday INTEGER;
vname VARCHAR2(255);

BEGIN
vday := '&&days';

SELECT cust_name
INTO vname
FROM Customers C, Orders O
WHERE C.cust_id = O.cust_id
AND O.order_date = '&&days'
;
END;
/

Im sure Im probably doing it all wrong, but hey, this is MY first query, and Ive not even been trained properly (sigh)

Hope that helps!