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: Difference between table level and column level NOT NULL constraint?

Re: Difference between table level and column level NOT NULL constraint?

From: Heinz Kiosk <no.spam_at_ntlworld.com>
Date: Sat, 23 Feb 2002 09:10:44 -0000
Message-ID: <R2Jd8.13060$H43.1550711@news11-gui.server.ntli.net> 





Putting in the Not Null when you create the table will always work.



Putting it in with an Alter Table later will not work if there are any rows
in the table.



Regards
Received on Sat Feb 23 2002 - 03:10:44 CST












Original text of this message













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