Re: add not null constraint to existing column SQL /Oracle
Posted 13 April 2009 - 01:37 PM
Hm, I don't have a active Oracle box to test it atm. On what character that error occurs? If you cannot set a notnull-only contraint, I guess you cannot name a single not null. Strange, As you should be able to create any constraint you want. Maybe you can use a CHECK constraint, but that's harder to perform for the database.