SQL Language (MOSC)

MOSC Banner

selecting column having parentheses in column name.

edited Jun 19, 2015 8:54PM in SQL Language (MOSC) 7 commentsAnswered ✓

One of our tables is having parentheses in its column name and when we are trying to select that particular column we are getting error

SQL> desc reqhist

Name                                                                                   Null?                      Type

-------------------------------------------------------------------------------------- -------- ----------------------------------------------------------

REQUEST_ID                                                                 NOT NULL                NUMBER(15)

  parent                                                                                                             VARCHAR2(40)

PHASE_CODE                                                              NOT NULL                  VARCHAR2(1)

STATUS_CODE                                                            NOT NULL                  VARCHAR2(1)

  PROGRAM                                                                                                     VARCHAR2(273)

ACTUAL_START_DATE                                                                                   DATE

ACTUAL_COMPLETION_DATE                                                                        DATE

Timetaken(Mints)                                                                                       NUMBER

ARGUMENT_TEXT                                                                                          VARCHAR2(240)

SQL> select Timetaken(Mints) from reqhist;

select Timetaken(Mints) from reqhist

       *

ERROR at line 1:

ORA-00904: "TIMETAKEN": invalid identifier

SQL>

Kindly helps us in this issue.

Regards,

Surya Prakash.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center