Hi:
I want to load 16:25 into Number filed as 16.25 from flat file using sqlldr.
any suggetion?
Thanks.
Printable View
Hi:
I want to load 16:25 into Number filed as 16.25 from flat file using sqlldr.
any suggetion?
Thanks.
if there is no : any where other than the values like 16:25, do a global replace with . in the flat file itself...
You could also try in your control file:
...
my_nbr position(..) "REPLACE(:my_nbr,':','.')",
...
;)