Value from Column in the Database Is Not Displayed With Exact Same Scale as Sql*Plus When Using JDBC (Doc ID 1362964.1)

Last updated on JULY 29, 2019

Applies to:

Symptoms

The value from the database column is not displayed with the exact same scale when using a Java program with JDBC.

For example:

SQL> create table test(id number(3,2));

Table created

SQL> insert into test values(1.20);

SQL> commit;

SQL> col id for 9.99
SQL> select id from test;

ID
-----
1.20



This gives the correct result , but it is not the same if  JDBC Thin driver is used in below code:

The result from the java program is again:

1.2

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.