How to set the default value of a database column to NULL
436767May 26 2009 — edited Jun 25 2009Hello,
I want to set the default value of a column (VARCHAR2(20) to NULL, nut I cannot figure out to do this. I tried the following editing the offline table with JDeveloper:
Default Value : <empty> -> On database NULL
Default Value: '' -> On database ''
When I create a new column, there is no default value on the database side and when I open the tabe properties in the database navigator I can see that the default value is (null). This is what I want to see in the other column as well. I don't know why sometimes a default value is visible on the database side (when generating form offline tables to database tables) and sometimes not.
Perhaps sombody can bring some light in this issue.
Thanks Thomas