Hi Brad,
When Oracle stores NUMBER data it treats it as variable length and only
uses as many bytes as are needed to hold the current contents. The only
place that length matters is on output because Oracle must reserve enough
space in the output line to hold a maximum length value.
regards
Jerry Gitomer
brad_pybus_at_my-deja.com wrote in message <7j3qfn$p78$1_at_nnrp1.deja.com>...
>I'm trying to find some information on how to map the numeric data
>types of SQL server to the NUMBER data type of Oracle. For some
>reason, every migration text I come across on the internet keeps saying
>change tinyint, smallint, and int all to NUMBER. That seems like a big
>waste of space!!!! I am looking for something like this:
>
>(HYPOTHETICAL EXAMPLE!)
>
>SQL SERVER ORACLE
>---------- ---------
>smallint NUMBER(2)
>tinyint NUMBER(3)
>int NUMBER(5)
>
>Anybody out there know this information or know why all the migration
>documentation keeps saying to convert all these types to just NUMBER??
>
>Thanks,
> Brad
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 03 1999 - 09:58:41 CDT