Is there a way to select a field into a variable using SQL such as:

SELECT field INTO variable FROM table WHERE field = value

I am using an Oracle database connecting through odbc.