Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid column name problem

Re: Invalid column name problem

From: Steve <alan_bo_at_hotmail.com>
Date: 18 Sep 2001 08:46:29 -0700
Message-ID: <15c65e2b.0109180746.fe0c991@posting.google.com> 





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

By this way, you can not see the not null definition after issuing:


"desc tabke_name"; So, alternatively, you can:

"ALTER TABLE dept MODIFY (loc char(30) CONSTRAINT nn_loc NOT NULL);"

Received on Tue Sep 18 2001 - 10:46:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US