I want to load data dumped by Informix unload command. If the field delimiter or a newline is found in values, Informix unload will use escape '\'. How do I load it to Oracle? Does SQL*Loader recognize escaped characters? What other tools may I use?
For example, the following data should be one record in Oracle. Thanks.
1|this is a test\
with newline in values