title: Need INSERT QUERY for DATE column Values in Oracle 11G
body: <pre><code>INSERT
  INTO TABLE_NAME
    (
      SEQ_ID,
      FIRST_ENTRY_DATE,
      UPDATE_DATE,
      TRIGGER_DATE,
      EMPLOYEE_NAME
    )
    VALUES
    (
      'I001247476',
      NVL('27/12/2014',SYSDATE),
      SYSDATE,
      TO_DATE('26/10/2014', 'MM/DD/YYYY HH24:MI:SS'),
     'JHON'
    );
  </code></pre>
  
  <p>Date is coming in <code>DD/MM/YYYY</code> format but in query declared as <code>MM/DD/YYYY</code>.
  How to handle this thing explicitly in query we cannot directly change the format or date in the above query.
  <strong>Any function available in oracle to handle this kind of scenarios?</strong></p>