When querying data with decimal values, the data returned is rounded off.
For example, querying
SELECT 123.1, 123.15 FROM dual; returns the following results in TOAD:
However, the same query in SQL*Plus does not receive the same results. In SQL*Plus it results: 123.1 and 123.15.
Upgrade Oracle Client from an Oracle 806 to at least an Oracle 8i