Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! New user

Re: Help! New user

From: Troy Perchotte <perchott_at_digitalcourier.com>
Date: Thu, 09 Apr 1998 11:06:32 -0700
Message-ID: <352D0E28.21A2986A@digitalcourier.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US