Default column values

From: <oradba_n_az_at_my-deja.com>
Date: Fri, 20 Oct 2000 19:08:47 GMT
Message-ID: <8sq57p$kjs$1@nnrp1.deja.com>

I have a test table with a date column, a varchar2 column and a number column with a default value of 50. When I insert data into the table and leave the number field blank (NULL), it stays NULL (doesn't insert the default value of 50). If I modify the column to be NOT NULL and try to insert the same data, I violate the NOT NULL constraint. How does the default value get inserted into the table when no value is given in the insert statement?

Thanks!!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 20 2000 - 14:08:47 CDT