PL SQL Where Clause with Column/Field name being a datatype

Question

Quick question playing with PL SQL it seems that the tables column was named as the data type NUMBER so trying to perform a query fails since the column is being recognized as a datatype instead of a column name. Anyone know how to get around this without modifying the schema?

EDIT:

Thanks everyone for the help yeah the issue was it had to be in quotes and was case sensitive.

Answer 1

Try wrapping a column name in single or double quotes.

Answer 2

Try putting the column name in double quotes ("column_name")

Answer 3

Place it between double quotes and the case of each character must match the case of the corresponding character in the column name exactly.