title: Update Not Null Column with Default Value Fails
body: <p>Please forgive me if this is a basic question.  I'm not much of an Oracle developer and Google has failed me so I turn to you.</p>
  
  <p>I have two schema's in the same database.  They both have the same structure.  I have a table with a column defined as...</p>
  
  <p>longitude_coordinate   NUMBER(16,8) default 0 not null,</p>
  
  <p>...if I run the query...</p>
  
  <pre><code>UPDATE table SET longitude_coordinate = null WHERE id = xxxxxxxx
  </code></pre>
  
  <p>...on one schema it succeeds on the other it fails with the error....</p>
  
  <p><strong>ORA-01407</strong>: </p>
  
  <blockquote>
    <p>cannot update ("SCHEMA"."TABLE"."LONGITUDE_COORDINATE") to NULL.  </p>
  </blockquote>
  
  <p>I'm assuming there must be some global option but I can't locate it for the life of me.</p>