Q: Not Null constraints
From: BO/EBC/KX/RGFC Roger Bjaerevall 08-682 4851 <ebcrbj_at_ebcw150.ericsson.se>
Date: Thu, 4 Aug 1994 12:00:10 GMT
Message-ID: <1994Aug4.120010.15509_at_ericsson.se>
Date: Thu, 4 Aug 1994 12:00:10 GMT
Message-ID: <1994Aug4.120010.15509_at_ericsson.se>
NOT NULL constraints can be named in the table definion.
Is it possible to get the constraint name upon a request that inserts a NULL value into the column?
Even if the constraint is named I'll get this message:
ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert
Quite hard to find out which column that failed ;-)
+------------------------------------------------------------------+
+ _/_/_/ _/_/_/ _/_/_/_/ Roger Bjärevall + + _/ _/ _/ _/ _/ BO/EBC/FL/RGFC + + _/ _/ _/ _/ _/ Ericsson Business Networks AB + + _/_/_/_/ _/_/_/_/ _/ 135 83 Tyresö + + _/ _/ _/ _/ _/ _/ Sweden + + _/ _/ _/ _/ _/ _/ +46 8 6824851 + + _/ _/ _/_/_/ _/_/ email: ebcrbj_at_ebc.ericsson.se +Received on Thu Aug 04 1994 - 14:00:10 CEST
+------------------------------------------------------------------+