8 Replies Latest reply: Jul 24, 2013 1:37 AM by 1024977 RSS

    select query to select a column named NUMBER

    Sreekeshava S
      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)