Number Data may be Displayed as Tilde or ~ When Selecting Data of Exponential Notation Using SQL*Plus (Large Number of Significant Digits)

(Doc ID 2353402.1)

Last updated on JANUARY 26, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 and later
Oracle Database - Standard Edition - Version 9.2.0.8 and later
Information in this document applies to any platform.

Symptoms

When the contents of a number column stores data with significant digits greater than or equal to 11 digits, The data returned in SQL*PLUS may be displayed as a tilde or ~.

For Example:

SQL> create table num_test (id number, num number);

Table created.

SQL> insert into num_test values (1,9.9999E+125);

1 row created.

SQL> select * from num_test;

ID           NUM
---------- ----------
1             ~                  <---

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms