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

I recreated the table and loaded the data into it again.

Thanks to Guang, Tom Mercadante, Dennis for the suggestions.

Rao

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, February 28, 2003 2:39 PM

> Hi All,
>
> Thanks for the replies.
>
> I tried to select the column with --- select "NAME" from messages;
>
> I am getting the ORA-904 error.
>
> I would try to recreate the table, import the data and let you know.
>
> Rao
>
> -----Original Message-----
> Sent: Friday, February 28, 2003 2:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Rao,
>
> Change your select to
>
> select "NAME" from messages;
>
> to fix this, you will either need to drop and recreate the table
> (without
> the quotes), or add the column NAME (
>
> alter table messages add(name varchar2(n))
> update messages
> set name = "NAME";
> alter table messages drop column "NAME"
>
> good luck!
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Friday, February 28, 2003 1:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> 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: <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: Chuck Hamilton
  INET: chuckh_at_softhome.net

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: <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).