When I ran a SELECT from Toad for a NUMBER datatype, Toad displays more decimal than SQL PLUS.
For example, if Toad shows 0.799999999, SQL PLUS would only show 0.8.
SQL PLUS rounds if a number is larger than the value of its SET NUMWIDTH. Try the following query in SQL PLUS and see if SQL PLUS will show the complete value.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center