Put NAME into lower case and enclose it in double quotes.

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to