Skip to Main Content
Forums

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table storing Decimlas even if populating non- decimal values in NUMBER datatype column

G VijayJun 11 2018

Hi All,

     I have one custom table where TIBCO inserting some data. the input what TIBCO receives doesn't have any decimals in the number value but while inserting into the table it is showing decimals that too constant like 123.99 so all values has 0.99 apended with the value. Can you please let us know what could be the reason. TIBCO is not doing any formatting and this is not happening for all insertions.

Thanks in advance.

-Vijay

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 9 2018
Added on Jun 11 2018
#sqlとpl-sql, #データベース
0 comments
128 views