My Oracle Support Banner

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 AUGUST 04, 2018

Applies to:

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


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             ~                  <---




To view full details, 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 a vibrant support community of peers and Oracle experts.