Re: Invalid column name problem

Jordan wrote:
>
> 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?

   alter table dept add constraint chk_loc CHECK (LOC IS NOT NULL)

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia