Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid column name problem
Hi there,
You can either use
alter table dept modify (loc varchar2(13) not null) or
alter table dept add constraint chk_loc check (loc is not null)
Allan W. Tham
DBA
Received on Wed Sep 19 2001 - 04:30:25 CDT