What's the equivalent of the Access "WHERE table!field = '[User Input]';" in Oracle?

I want to be able to input a value for the query to work on.