1 Reply Latest reply: Oct 14, 2013 3:32 PM by Barbara Boehmer RSS

    How to insert float values into external tables


      Hi all,


      I need a help


      I have a text file like as following ,




      I am using oracle loader to insert this values into external tables

      I want  the table structure as following.



      id_type=SKU(position1:3),id_value=76079078(position 4:11),reason(position 12:15),sign(position 16),qty(17:28)


      i this if you see the qty 000000010000 from 17 to 24 it is number and after this(25 to 28) its decimal part

      E.g  000000010001 =1.1


      Please guide me how can i declare this