Oracle-L: RE: Invalid column in table

From: gmei <gmei_at_incyte.com>
Date: Fri, 28 Feb 2003 11:04:39 -0800
Message-ID: <F001.0055D3FB.20030228110439@fatcity.com>

Use: Select "name" from messages;

See this example:

SQL> create table t1 ("col1" number);

Table created.

SQL> desc t1;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 col1                                               NUMBER

SQL> insert into t1 (col1) values (1);
insert into t1 (col1) values (1)

ERROR at line 1:
ORA-00904: invalid column name

SQL> insert into t1 ("col1") values (1);

1 row created.

SQL> select col1 from t1;
select col1 from t1

*
ERROR at line 1:
ORA-00904: invalid column name

SQL> select "col1" from t1;

col1

Guang

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> maheswara.rao_at_sungard.com
> Sent: Friday, February 28, 2003 1:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Invalid column in table - how to access it?
>
>
> I have a table - messages. I couldn't access one column in this table
> when I do
>
> Select name from messages;
>
> I get an error message - ORA-00904: invalid column name
>
> All the other columns I could select from this table. When I checked
> the table structure through OEM, I found this column has double quotes
> around it i.e., "NAME". All other columns do not have double quotes
> around their name.
>
> Question:
>
> How do I select this column from select statement?
>
> How do I correct this problem?
>
> Thanks for the help in advance.
>
> Rao
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <maheswara.rao_at_sungard.com
> INET: maheswara.rao_at_sungard.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: gmei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Feb 28 2003 - 13:04:39 CST

RE: Invalid column in table - how to access it?