title: How to insert date in Oracle 10g xe?
body: <p>I  did the following:</p>
  
  <ol>
  <li><pre><code>  CREATE TABLE BOOK(
            BOOK_ID VARCHAR(4) PRIMARY KEY,
            ISBN_10 VARCHAR(10),
            TITLE VARCHAR(50),
            CATEGORY VARCHAR(25),
            PRICE DECIMAL(6,2),
            BINDING VARCHAR(2),
            PUB_DATE DATE,
            AUTHOR_ID SMALLINT,
            PUBLISHER_ID SMALLINT
            );
  </code></pre></li>
  </ol>
  
  <p>2.</p>
  
  <pre><code>ALTER SESSION SET nls_date_format = 'DD-MM-YYYY HH24:MI:SS';
  </code></pre>
  
  <p>3.</p>
  
  <pre><code>INSERT INTO  BOOK
  VALUES('4','123459','INTRODUCTION TO SmallTalk','IT',157.00,'S',**'26-01-1991'**,13,103);
  </code></pre>
  
  <p>It gave an <strong>error</strong>:
   <strong>ORA-01843: not a valid month</strong></p>
  
  <p>However if do the <strong>following</strong> there is <strong>no problem:</strong></p>
  
  <p>Query:</p>
  
  <pre><code>INSERT INTO 
  BOOK
  VALUES('4','123459','INTRODUCTION TO Small Talk','IT',157.00,'S','**26-JAN-1991**',13,103);
  </code></pre>
  
  <p>Can anyone explain why?</p>