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...
Last edited by adewri; 02-24-2003 at 12:10 PM.
Amar "There is a difference between knowing the path and walking the path."
You could also try in your control file: ... my_nbr position(..) "REPLACE(:my_nbr,':','.')", ...
Forum Rules