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

    How to insert float values into external tables

    47e033bd-d313-47bd-9372-871358ce3c3e

      Hi all,

       

      I need a help

       

      I have a text file like as following ,

      SKU760790780023-000000010000

      SKU774507910023-000000010000

       

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

      I want  the table structure as following.

       

      Id_type,id_value,reason,sign,qty.

      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