As
Tom Kyte says[
^]: "
SQLPlus has a default number format is uses to display data on the screen "nicely". You need to
either
o set the numformat to something you like
o use a TO_CHAR on the number with a format that applies in your case.
Info on how to set Numformat
here[
^].