Oracle

[gravyboy]

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.

[kovan]

same thing
SELECT blah, blah2 FROM mytable WHERE blah2 = 'userinput'

[gravyboy]

What's wrong with this?


ACCEPT dte CHAR PROMPT "DATE ADDED:"


. . . . . . . . . . .