A column named "NUMBER"

From: D. Alvarado <laredotornado_at_zipmail.com>
Date: 11 Oct 2004 10:37:40 -0700
Message-ID: <9fe1f2ad.0410110937.6fd68203@posting.google.com>

Hi, I'm running Oracle 8.1.7 for Solaris. I'm not sure how this condition came about in my environment, but a table was created and it contains a column named "NUMBER". That is not the data type, that is the actual column name (The data type is VARCHAR2(4)).

So, when I try to update this column, like so

UPDATE SCHOOLS SET NUMBER = '1234' WHERE PID = '00000024' I get the error

ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification

What can I do to properly update this column? IOf course, I will make every effort to track down the person that created this table and harass them.

Thanks, - Dave Received on Mon Oct 11 2004 - 12:37:40 CDT