Is there any way I can specify delimeter for new lines ?? in sql loader.
I have a data where people insert from notepad and which is formated.
when I am trying to load it oracle is considering new lines as another record though it is one field made of multiple lines ..

any help appriciated