My Oracle Support Banner

Scientific Notation in SQL Talk Window (Doc ID 142709.1)

Last updated on JULY 16, 2007

Applies to:

Oracle Financial Data Manager - Version:
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA)


You notice that some numbers appear as scientific notation in the SQL Talk window.  However, the numbers are correct when querying them in another tool (SQL*Plus, etc.). This behavior is observed with columns having a datatype of NUMBER, precision & scale greater than (8,4), and four or more leading zeros to the right of the decimal.

For example, in SQL*Plus the query returns:
SQL> select cur_net_rate from commercial_loan where id_number=107;


However, in SQL Talk, the query returns:



You may have modified the column size (changing precision and scale) or you may have added 4 or more leading zeros to the right of the decimal.


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.