PL / SQL在Adhoc SELECT中使用变量

I'm (attempting) to write a query which will use the same date at several points in the query. I'd like to use a variable to make it easier to run the query for different dates. How would I do that? I'm getting assorted errors when I try to execute the query as it is. I'm (attempting) to write a query which will us