Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A column named "NUMBER"
Use double quotes around the column name. That will also make it
case-sensitive, so you may need to experiment.
"D. Alvarado" <laredotornado_at_zipmail.com> wrote in message
news:9fe1f2ad.0410110937.6fd68203_at_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 - 14:42:15 CDT