• The thing is, Oracle does not really have binary integer datatypes the way that SQL does. I think that there may be something like PLS_INTEGER which is equivalent to INTEGER in SQL Server, but that is about it.

    This makes for real problems when moving data back and forth. Because the SQL Server Integer sizes are between the decimal sizes that Oracle uses, which size you use depends on whether you are moving data from Oracle to SQL Server or from SQL Server to Oracle. Effectively, the receiver of the data always has to round up the number of digits from the sender.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]