Avatar of sumanth_ora

asked on 

How to convert Exponential Value to exact number in oracle database


I See the data in the databas table (From Toad) as follows.
--------------------------------------------------------Discount table data diplays as follows.
123456789                                2.11998576577681E17                                  5

1.select * from discount   where transaction_id=2.11998576577681E17 doesn't fetch any records even though it is available in the database

2.And Join conditions  like  DISCOUNT.TRANSACTION_ID=TRANSACTION.TRANSACTION_ID  will give me problem?

Please help.It is very Important and urgent Issue.

Oracle Database

Avatar of undefined
Last Comment
Sean Stuber

8/22/2022 - Mon