The Oracle (tm) Users' Co-Operative FAQ

I have a column with a default value, but I keep finding it set to NULL - what's going wrong ?.


Author's name: Sergey M

Author's Email: bigwizard@mail.ru

Date written: 25th Oct 2001

Oracle version(s): 7 - 8.1.7

I have a column with a default value, but I keep finding it set to NULL - what's going wrong ?

Back to index of questions


Because a default value is used only for insertion into a table, but you may update the value of column to NULL


Further reading: N/A


Back to top

Back to index of questions