Re: Help! New user

Yes, there is a reason this works:

Oracle, by default, keeps all column names in the catalog in UPPER case. We don't have to enter our SQL in upper case, the parser does the conversion for us.

However:

Some people like mixed case column names. The only way to get Oracle to record a mixed case column name is to wrap it in quotes. Having done that, you must forever refer to that column name in quotes!

Some tools (MS ACCESS) like mixed case, even in Oracle tables. I'll bet the Oracle table was created through some such tool. Of course, it could have been done in SQL*Plus by using quotes.

Troy Perchotte wrote:
>
> Thanks John. Is there any particular reason why this worked though - as the
> examples from oracle do not use quotes around their column names?
>
> John P. Higgins wrote:
>
> > Try this:
> >
> > select * from dci.customer where "CustID"=5;
> >
> > Troy Perchotte wrote:
> > >
> > > When I run this statement I get "ora-00904: invalid column name":
> > >
> > > select * from dci.customer where custid=5;
> > >
> > > CustID is the primary key in this table, and is displayed when I exclude
> > > the where clause.
> > >
> > > Troy Perchotte
Received on Thu Apr 09 1998 - 13:50:01 CDT