By default, sql loader use \n as the line terminator. i.e. as soon as it sees a \n, it treat anything behind it as the new line.
However, one of columns in my output file also has \n inside. This did confuse SQL Loader since it thought that's the end of the line while there are still many columns after that.
So how can get this problem resolved?
I can regenerate the data file, so that file will be a different line terminator (do differentiate from \n). But can I specify the new terminator in the SQL Loader's control file? If yes, how?
I've been looking at different resources, but haven't got any luck. Your help is very much appreciated!
If you are on 8i or 9i you can specify your own line terminator, using so-called "Stream Record Format". Example:
infile 'example.dat' "str X'7c0a'"
into table example
fields terminated by ',' optionally enclosed by '"'