Re: Invalid column name problem

"Jordan" <warlord_at_netvigator.com> wrote in message news:<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?

Jordan,

try
alter table dept add constraint chk_loc ("LOC" NOT NULL);

Ronald.