sqlplus output - how to avoid it returns blank value when column*1 document that row/column has a va

Hi,

after debugging a whole day without finding a solution, its time to try this forum.

Could some one explain this and how to avoid it (see result of first and last query), it happens both on instantclient 12.x (Windows) and 19.x (Linux) on around 20 out of approx. 50000 rows:

select ID, XXXXXXXXXFEE from userx.campaigntable where ID =5278;

select ID, XXXXXXXXXFEE*1000 from userx.campaigntable where ID =5278;

select ID, XXXXXXXXXFEE*100 from userx.campaigntable where ID =5278;

select ID, XXXXXXXXXFEE*10 from userx.campaigntable where ID =5278;

select ID, XXXXXXXXXFEE*1 from userx.campaigntable where ID =5278;

      ID   XXXXXXXXXFEE

---------- --------------

      5278

      ID   XXXXXXXXXFEE*1000

---------- -------------------

      5278                  .2

      ID   XXXXXXXXXFEE*100

---------- ------------------