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: 17 Sep 2001 08:03:18 -0700
Message-ID: <15c65e2b.0109170703.6a988bad@posting.google.com> 





Try one thing:



alter table dept modify( loc CHAR(30) constraint loc_nn NOT NULL);



And that is the correct syntax.



HTH,


Steve
Received on Mon Sep 17 2001 - 10:03:18 CDT












Original text of this message













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