We all know Primary key doesnt treat NULL as a value. But the above statement is fine to be executed without problem. Is this something to be highlighted? or am i not right in understanding 'var1 varchar2(20) null '?
Joined: 11-March 08
Member No.: 18,933
There is a huge difference between creating a table (with constraints in place) and actually inserting data into it. If there are no values in a table (because you just created it), then what is the issue? All the constraint means is that when data is present, with a PK defined, that the PK value is unique AND not null.