How to enforce the default value of a column?
January 9th, 2006 By Francois Degrelle
SQL> create table test_default( col1 number(5) default 10 )
2 /
Table créée.
SQL> insert into test_default values( default )
2 /
1 ligne créée.
SQL> select * from test_default
2 /
COL1
----------
10
(Since Oracle 9i)