title: Find numeric subtype (smallint, int, etc) in oracle
body: <p>I added a table in oracle in oracle with fields - </p>
  
  <ul>
  <li>smallint</li>
  <li>int</li>
  <li>bigint</li>
  </ul>
  
  <p>But it internally store them as <code>decimal(22,0)</code></p>
  
  <p>Is there any way to get individual subtype (<em>e.g. smallint</em>) instead of decimal.</p>
  
  <p><strong>My usecase:</strong></p>
  
  <p>I am using sqoop to copy data from oracle to hive. I need to check metadata of columns of oracle table and wrote own oracle to hive data type mapping.</p>
  
  <p>But I am always getting <code>decimal(22,0)</code>, so I need to map all these columns to <code>decimal(22,0)</code> in hive table even for smallint. </p>