This discussion is archived
8 Replies Latest reply: Jul 23, 2013 11:37 PM by 2b8a228c-c064-4bf5-9cd2-2dd78943b94c RSS

select query to select a column named NUMBER

SreekeshavaS Newbie
Currently Being Moderated
Hi all,

I have a table which is having a COLUMN NAME as NUMBER whose DATA TYPE is VARCHAR2(90 BYTE).

How should I select the column named NUMBER.

I am trying the sql query through SQL Developer.

I tried with following options.

1) select NUMBER from table_name
2) select [NUMBER] from table_name
3) select "NUMBER" from table_name
4) select [table_name.NUMBER] from table_name

But i did'nt succeed through the above queries. all the above queries are giving error.

So, please help me in this regard to query the column named NUMBER (which is a reserved word in Oracle)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points