DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: difference between NUMBER col and INTEGER col

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    I know Oracle allows column definitions of INTEGER for compatability with other databases. This then creates columns with definition of NUMBER(38). How wasteful is this? Would I be better finding out from my third party what definition these columns really should be e.g. NUMBER(4)????

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Not exists differense between INTEGER and NUMBER(38) on internal oracle level.
    Oracle convert INTEGER --> NUMBER(38) in any way.

    in PL/SQL (not in SQL) exists differense between NUMBER(38) and BINARY_INTEGER and PLS_INTEGER only.

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Yes .. so what I need to know is how wasteful is - or what are the pitfalls of - making NUMBER columns too long?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width