Trimming of blanks in sqlldr
Hi,
Thanks for your reply, but that is not what I want. I am using terminated by clause. My question is a value ^^ aaa ^^ is being loaded as one having two blanks on either side.
I want to trim from both sides and can not used functions as I am using direct=true, neither I want to do that by some post load processing logic.
Is there is sqlloader itself something which I am missing?
Kailash pareek
Trimming of blanks in sqlldr
Hi,
Thanks for ltrim/rtrim. My data is millions of rows and I am using DIRECT=TRUE. The sql operators are not allowed in direct mode.
Any more suggestions ?
kailash pareek