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

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

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

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

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!

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

Title: RE: Invalid column in table - how to access it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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

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

PROTECTED] 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

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

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

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

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

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 [EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:39 PM Hi All, Thanks for the replies. I