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?
>
> Best Regards,
> Jordan
>
>

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

Please take another cup of coffee, before you post another question, or try to read your syntax diagrams more carefully.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 16 2001 - 02:10:06 CDT