Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INTEGER vs NUMBER

602428Sep 24 2008 — edited Oct 2 2008
Not sure if this is covered anywhere else.

Recently I was confronted with a datamodel, that defines certain columns as INTEGER.
Usually I have noticed that the standard practice is to have numeric columns as NUMBER.
Is there a real advantage over using a column that is INTEGER vs a column defined as NUMBER. ( Not interested in the decimals at all in this case).

Let me know your thoughts.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2008
Added on Sep 24 2008
7 comments
756 views