NUMBER format question

  • From: "James Parkhurst" <jfpark137@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 5 Dec 2007 13:39:48 -0500

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

Other related posts: