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:
123.1, 123.2
However, the same query in SQL*Plus does not receive the same results. In SQL*Plus it results: 123.1 and 123.15.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center