Skip to Main Content
Forums

SQL Developer

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!

V4.1 Run Script now shows in scientific notation

DW_DBA_IEMar 15 2016 — edited Mar 16 2016

Previous versions of SQL Developer displayed output in the Script Output tab in full number format. In Version 4.1 it's now showing in scientific notation.

I didn't see any options in preferences to change this. It would be nice to not have to issue the COL command for every single column. Most of our PK/ID fields are NUMBER(16,0) and it is painful to have to issue COL commands for every column.

pastedImage_0.png

It works fine the the Query Result tab.

pastedImage_3.png

Oracle version 11.2.0.2 - 64-bit (though I'm not sure it matters).

Am I missing a preference somewhere or is this a new "feature".

Kind Regards,
Dawn Wisniewski
This post has been answered by thatJeffSmith-Oracle on Mar 15 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2016
Added on Mar 15 2016
#sql-developer
5 comments
442 views