Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting rid off exponential values

894770Jan 13 2012 — edited Jan 13 2012
Im spooling sqlpus output to unix file. when spooling i get exponential values like “6.2973E+10” .

Im using the following sqlplus settings

 SET HEAD OFF PAGES 0 TERMOUT OFF FEEDBACK OFF SQLBL ON TRIMSPOOL ON SPACE 0
 SET LINES 4000

how to get rid off the exponential values
Edited by: 891767 on Jan 13, 2012 12:48 AM
This post has been answered by BluShadow on Jan 13 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2012
Added on Jan 13 2012
#9i
7 comments
5,878 views