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: John P. Higgins <jh33378nospam_at_deere.com>
Date: Wed, 08 Apr 1998 21:19:02 -0500
Message-ID: <352C3016.5BE7@deere.com>


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 Wed Apr 08 1998 - 21:19:02 CDT

Original text of this message

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