Any comments ?
Setting the default to an explicit null is the advice from the manuals, so I supposed there's no better option.
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 10th Jan 2006
We had an app where some columns had default values. So life changes and now we don't need them. Question is how to get rid of them?
Of course one can alter table with default value null. It seems that functionally result is the same as without ever declared default value for the column although data dictionary return different results...
Any comments? ;)