Nome da Constraint NOT NULL

[diegolenhardtParticipante]

fiz uma busca aqui,

aparentemente são a mesma coisa, mas segundo um post que encontrei é uma forma mais conveniente de fazer, um caminho mais pratico.

How exactly would you like Oracle to check whether value inserted into column A is not null? I mean, what’s wrong with this? “NOT NULL” is here just for your convenience; this could be done this way:
Code:

CREATE TABLE abc
(a number NOT NULL,
b number CHECK (b IS NOT NULL));

Both work the same way, and both add a row into the user_constraints table.

http://www.dbforums.com/oracle/1119093- … olumn.html
[/quote]