title: Oracle 11g - "DEFAULT ON NULL"?
body: <p>I am running Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, I am trying to find an equivalent to 12c's "DEFAULT ON NULL" for a table. Basically I have to create a table where the requirement is than whenever someone intentionally or inadvertently passes a NULL value, it is replaced with a DEFAULT value (in this case a NUMBER type equal to 1). Is there any easy way to do this in 11g? I know I could do a trigger on the table, but I would have to put in logic for every single column, and that seems ridiculous.</p>
  
  <p>My table definition currently looks like this:</p>
  
  <pre><code>CREATE TABLE MYTABLE
  (
      FLAG   NUMBER(1)   DEFAULT 0
  )
  </code></pre>
  
  <p>If I explicitly pass in null it WILL get stored. In that situation I was expecting the default value to be placed instead.</p>