title: ORA-01858 Error in an Oracle SQL Table
body: <p>I've been fighting with this problem for a few days.</p>
  
  <p>I created the next table in Oracle's SQL Developer:</p>
  
  <pre><code>CREATE TABLE EMPLEADOSMM (
  ID_EMPLEADO VARCHAR2 (10) PRIMARY KEY,
  NOMBREEM VARCHAR2 (15) NOT NULL,
  AP_PATEM VARCHAR2 (20) NOT NULL,
  AP_MATEM VARCHAR2 (20) NOT NULL,
  FECHA_NAC DATE NOT NULL,
  FECHA_ING DATE NOT NULL,
  ID_CARGO VARCHAR2 (10));
  </code></pre>
  
  <p>Then, I proceeded to add some values to the table, the thing is that it added some like this:</p>
  
  <pre><code>INSERT INTO EMPLEADOSMM VALUES ('100006','OSCAR','MARIN','PEREZ','12-jul-85','15-nov-17','C0002');
  </code></pre>
  
  <p>But this others send me the 'ORA-01858: a non-numeric character was found where a numeric was expected' error.</p>
  
  <pre><code>INSERT INTO EMPLEADOSMM VALUES ('100004','FABIAN','RODRIGUEZ','VELEZ','31-aug-87','13-jul-17','C0003');
  INSERT INTO EMPLEADOSMM VALUES ('100005','LUZ MARIA','TORINO','YAÑEZ','11-dec-90','13-jul-17','C0003');
  </code></pre>
  
  <p>I tried changing the year format by "yyyy", rewriting all the zeros, but nothings seems to work. Some ideas?</p>