Re: A column named "NUMBER"

D. Alvarado wrote:

> 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

Should be able to override the default column naming (upper case, no imbedded blanks, starts with alpha, etc.) by surrounding the identifier with double quotes.

As you have noticed, once defined with unusual behavious, ALL references to the identifier need the double quotes.

TO track the culprit, look for the individual who likes using MS Access and has resource capability in your database. Based on my reading, it seems they [must?] use double quotes on all identifiers. (Surely you don't have shared userids <g>)

/Hans Received on Mon Oct 11 2004 - 12:53:18 CDT