Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert float values into external tables

1029527Oct 14 2013 — edited Oct 14 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2013

Added on Oct 14 2013

#database-key-features, #export-import-sql-loader-external-tables

1 comment

817 views