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: Jordan <warlord_at_netvigator.com>
Date: Mon, 17 Sep 2001 21:12:07 +0800
Message-ID: <9o4si1$7hl2@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> glsD :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 - 08:12:07 CDT

Original text of this message

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