trimming white space & blanks

[marist89]

Originally posted by marist89
You can apply the rtrim(ltrim()) function within your sqlldr control file.

For example:
fields terminated by x'12' optionally enclosed by x'15' (
field1 "rtrim(ltrim(:field1))",
...