I want to load 16:25 into Number filed as 16.25 from flat file using sqlldr.
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.
"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,':','.')",