My Oracle Support Banner

Number Is Displayed In Exponential Form Instead Of Pure Numeric Form (Doc ID 1293914.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle SQL Developer - Version: 1.5.3 to 3.0 - Release: to 3
SQL*Plus - Version: and later    [Release: Oracle9i and later]
Information in this document applies to any platform.


How to get data in the desired format?

Data is displayed in exponential form instead of numeric form.
Data displayed is 9.990000000000000000000000000000000E+125


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.