Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid column name problem
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