title: Inserting DECIMAL type to Oracle DB with SQL Developer
body: <p>Friends, i'm new in SQL and i can't find answer to my question</p>
  
  <p>I'm trying to insert decimal number with SQL Developer (version 4, build 15), but SQL Developer automaticaly rounding my number. My test DB is OracleXE112_Win64.</p>
  
  <p>Example:</p>
  
  <pre><code>CREATE TABLE salespeople
    (
      snum  INTEGER NOT NULL PRIMARY KEY,
      sname CHAR(15) NOT NULL,
      city  CHAR(15) NOT NULL,
      comm  DECIMAL
    );
  </code></pre>
  
  <p>then</p>
  
  <pre><code>insert into SALESPEOPLE 
  values (1001, 'Peel', 'London', .12);
  insert into SALESPEOPLE 
  values (1002, 'Serres', 'San Jose', .13);
  insert into SALESPEOPLE 
  values (1004, 'Motika', 'London', .11);
  insert into SALESPEOPLE 
  values (1007, 'Rifkin', 'Barcelona', .15);
  insert into SALESPEOPLE 
  values (1003, 'Axelrod', 'New York', .10);
  </code></pre>
  
  <p>As as result i see <strong>0</strong> in <strong>comm</strong> column.
  When i'm trying to insert number <strong>1.35</strong>, it's rounding to 1.</p>
  
  <p>Thanks</p>