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 laterOracle 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 ~ <---
Cause
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
Symptoms |
Cause |
Solution |