NUMBER format question

I have two tables on two different DB's, within two different servers. Both tables have the same structure and both DB's are of the same version ( 9.2.0.4). The column in question is of datatype NUMBER, w/o scale or precision.

If I log on to Server1, connect to DB1, and query the table's column, the results are returned in SQL*Plus with the decimal portion of the value intact.

If I log onto Server2, connect to DB2, and query the table's column, the results are returned in SQL*Plus w/o the decimal portion of the value.

If I log onto Server1, start SQL*Plus, then connect to DB2 remotely and query the data, the results are returned in SQL*Plus w/o the decimal portion of the value.

The session settings are identical via the SHOW ALL, and I've verified that the decimals are present on DB2 using a to_char and setting NUMFORMAT.

Anyone have any ideas why?

James

--
http://www.freelists.org/webpage/oracle-l