title: Compatibility Query for inserting null values in datefield
body: <p>I'm using Oracle and MySQL database in our project. So we are trying to write common queries for both databases. </p>
  
  <p>I'm trying to insert a date in a date field into both database tables. Both databases support this date format only: <code>2013-07-19</code>. In the course of our DML operations we are facing a problem when inserting dates as Empty or Null.</p>
  
  <p>Both databases have their own syntax to store an "empty field" in a Date field/column.</p>
  
  <p>MySQL allows dates as <code>0000-00-00</code> or <code>NULL</code> (specifically written at an appropriate position). But Oracle does not support this format. Oracle only allows date fields as <code>Empty</code>.</p>
  
  <p>How to write common queries in this type of situation?</p>