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!

formatting issue

g2500Mar 17 2016 — edited Mar 18 2016

Hi Team,

I am spooling records into a csv file from command prompt. one of the column is giving incorrect result.

I am getting this output :

4.00E+04

instead it should have been : 4E4

Has anyone encountered something like this?

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

Thanks

Jac

This post has been answered by g2500 on Mar 18 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2016

Added on Mar 17 2016

28 comments

2,984 views