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)

Symptoms

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;

CUR_NET_RATE
------------
.00001

However, in SQL Talk, the query returns:

CUR_NET_RATE
------------
1e-05

Changes

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.

Cause

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