Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! New user
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:06:32 CDT