title: Fetching decimal data from Oracle using Sqlalchemy
body: <p>Executing SQL over oracle using <code>sqlalchemy</code></p>
  
  <pre><code>QUERY = SELECT score as SCORE FROM USER1.TABLE1 WHERE id = 101 ORDER BY score DESC
  
  output = []
  results = db.engine.execute(QUERY)
  [output.append(dict(row)) for row in results]
  </code></pre>
  
  <p>Output:</p>
  
  <blockquote>
    <p>[{'score': Decimal('0.9556')},.....]</p>
  </blockquote>
  
  <p><em>score datatype - Number(16,14)</em></p>
  
  <ol>
  <li><strong>Even after aliasing it in uppercase, I am getting smallcase output.</strong></li>
  <li><strong>Can we remove <code>Decimal</code> in the output?</strong></li>
  </ol>
  
  <p>I tried casting score as float</p>
  
  <pre><code> SELECT CAST(score as FLOAT) as SCORE FROM USER1.TABLE1 WHERE id = 101 ORDER BY score DESC
  </code></pre>
  
  <p>I am getting output like,</p>
  
  <blockquote>
    <p>[{'score': 0.9191699999999999},.....]</p>
  </blockquote>