selecting column having parentheses in column name.
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.