Scientific Notation in SQL Talk Window
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:
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 hundreds of Community platforms