DanBrother的部落格

Solving Number Data Type Display Issue (Scientific Notation) in PL/SQL Developer:

Issue:
In PL/SQL Developper, when the column data type is number and the data value have more than 15 digits, the query result becomes scientific notation.

e.g.
select to_number('999999999999999')  as "15 Digits" from dual;
>> -- would be fine
999999999999999

select to_number('9999999999999990')  as "16 Digits" from dual;
>> -- would become scientific notation
9.99999999999999E15

Solution:

Tools -> Preferences -> Windows Types --> SQL Window --> Check on "Number fields to_char"
-> click APPLY -> OK

When press F8 (Execute) again, the result turns out be to normal.

select to_number('9999999999999990')  as "16 Digits" from dual;
>>
9999999999999990