1 Reply Latest reply: Jan 15, 2018 5:41 AM by Martin Eichinger RSS

    ORACLE: CONVERT NUMBER(17) TO STRING

    Martin Eichinger

      Hello!

       

      I have troubles to work with data stored as number(17) in oracle db. After loading data into app, i see a scientific representation of the number, which i can't handle.

       

      Definition in oracle db:

       

      1.png

      View of data in oracle db with Oracle SQL Developer:

      2.png

       

      View of data in Qlik Sense data manager after load:

       

      3.png

       

      How can i convert this scientific number to normal number or string, as represented in Oracle SQL Developer?

       

       

      Martin