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

Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid column name problem

Re: Invalid column name problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 17 Sep 2001 18:47:31 +0200
Message-ID: <tqcb16ol85go2c@news.demon.nl>


http://technet.oracle.com has all *flat* docs (with a master index) http://tahiti.oracle.com has all docs in searchable format. At the first site you need to subscribe, but subscription is free and instanteneous.

Regards,

Sybrand Bakker, Senior Oracle DBA

"Jordan" <warlord_at_netvigator.com> wrote in message news:9o4si1$7hl2_at_imsp212.netvigator.com...
> Thanks all of you. I will try my best to find more materials about
oracle.
> But I don't know where I can get it, can anyone help me?
>
>
> "Jordan" <warlord_at_netvigator.com> ¼¶¼g©ó¶l¥ó·s»D
> :9o1ih4$sci5_at_imsp212.netvigator.com...
> > Dear all,
> > During I used sqlplus / svrmgrl, when I refer some table
> > column, oracle always said that "invalid column name", e.g. a table
> "dept"
> > has the following structure
> >
> > Column Name Null? Type
> > ------------------------------ -------- ----
> > DEPTNO NOT NULL NUMBER(38)
> > DNAME NOT NULL CHAR(30)
> > LOC CHAR(30)
> >
> > When I type "alter table dept add constraint chk_loc (LOC NOT NULL)",
the
> > error message "ORA-00904: invalid column name" appears. I have tried
> using
> > different case and the problem still exists. Can anyone help me?
> >
> > Best Regards,
> > Jordan
> >
> >
>
>
Received on Mon Sep 17 2001 - 11:47:31 CDT

Original text of this message

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