<div>
<div class="content wysiwyg-content">
I have a Primary Key field with potential values from 1 to 99,999,999 - this field is a Foriegn key into a table with 2b+ rows . &nbsp;It is currently defined as a <br />
number(8) , what are the implications and impact of using and integer instead? &nbsp;<br />
<br />
Thanks &nbsp;
</div>
</div>


I have a Primary Key field with potential values from 1 to 99,999,999 - this field is a Foriegn key into a table with 2b+ rows .  It is currently defined as a 
number(8) , what are the implications and impact of using and integer instead?  

Thanks  

Data Types for Dummies ... INTEGER vs NUMBER(8)

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.