title: Oracle not accepting decimal numbers but instead coming up as null
body: <p>Using Oracle Express 11g and SQL developer, when I do any script or calculation, Oracle will not accept any number with a decimal point, returning null instead. As an example:</p>
  
  <ul>
  <li>If I do 2 divided by 3, the answer comes up as null, instead of .66</li>
  <li>10 divided by 4 comes up as null instead of 2.5</li>
  </ul>
  
  <p>Steps taken so far: I have set the tables and columns to various datatypes, defined the scale and precision, and verified the language/region settings.  </p>
  
  <p>Here is my database schema:</p>
  
  <pre><code>CREATE TABLE DCP_SITE_MAP 
  (
    LOCXREF VARCHAR2(20 BYTE)
  , XVALUE NUMBER(10, 2)
  , YVALUE NUMBER(10, 2)
  )
  </code></pre>
  
  <p>The values that I attempted to add to the DCP_SITE_MAP table:</p>
  
  <ul>
  <li>XVALUE = 13 : YVALUE = 5</li>
  <li>XVALUE = 13.25 : YVALUE = 5</li>
  </ul>
  
  <p>As a note, after I entered 13.25 and committed the entry, the 13.25 was changed to 13.</p>
  
  <p>Then I ran SQL like this:</p>
  
  <pre><code>SELECT XVALUE as Expr1,
         XVALUE *.25 as Expr2,
         XVALUE/YVALUE as EXPR3
  FROM DCP_SITE_MAP 
  </code></pre>
  
  <p>I would get a null value back from Expr2 and EXPR3. In addition, the following queries would also return null:</p>
  
  <pre><code>Select XVALUE/60 as EXPR2 from  DCP_SITE_MAP
  
  SELECT count(*)/60 from DCP_SITE_MAP
  </code></pre>