title: Oracle Default value on Number column
body: <p>I have a number column on a table called SampleTable which is defined as follows</p>
  
  <p>ID Number(10) DEFAULT 1</p>
  
  <p>I have a trigger on different table(SomeTable) and UPDATE EACH ROW (Trigger - :New.ID)  which inserts value from that table(SomeTable) into the SampleTable.</p>
  
  <p>Sometimes the ID from SomeTable can be NULL and I wanted to SampleTable to insert the default value 1 in my case.</p>
  
  <p>But it inserts NULL(Blankspace) on the table.</p>
  
  <p>I am kinda new to PL/SQL so any help is greatly appreciated.</p>