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 SEPTEMBER 13, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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 ~ <---