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