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