title: Oracle datatype to C# types
body: <p>I am trying to convert Oracle data types to C# equivalents.
  I execute queries something similar to this.</p>
  
  <pre><code>Select CAST ((CASE WHEN RateType = 1 THEN 2
                     WHEN RateType = 2 THEN 6
                     ELSE 18
               END) AS NUMBER(10))
  FROM SomeTable
  </code></pre>
  
  <p>There are case statements in that but ultimately my outermost statement is casting it to Number(10)</p>
  
  <p>Then I use OracleDataReader.GetSchemaTable to determine type of the column in my C# code. I am getting System.Decimal with precision 38 and scale 127.
  I was expecting an System.Integer with precision 10 and scale 0. Is this as  expected result or do i need to something different to determine column type? </p>