query trouble: column name is also keyword

[hlauwers]

I've got a table "x" with a column named "date"

When I run this query: "select date from x" an error is returned: "Error: ORA-00936: missing expression (State:37000, Native Code: 3A8)"

How should I modify the query in order to retrieve the data in the "date" column?

 

[lewisp]

Try

SELECT "date" from x

 

[alexhu]

have you tried with quotes around date?

Alex

 

[alexhu]

Thats what I like about this bulletin board - you don't know if someone else is adding to the post at the same time

Alex

 

[hlauwers]

Thanks! It worked: select "DATE" from x