lol agreed
;)
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tq8tpgt7idgr84_at_news.demon.nl>...
> "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 - 14:10:15 CDT
