Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Loader issue with LF

Oracle_MonkeyMar 16 2019 — edited Mar 21 2019

Hello,

As i understand the

LF -> Unix

CR LF -> Windows

CR->Apple

I have a .csv file that i get from mail in windows system.

eg . XYZ.csv its EOL(end of Line) is LF .

When i transfer the file to Unix system the sql loader control file  doesnt process the file  even the EOL is  LF which should be compatible with UNIX

But when i change the EOL to CR LF and transfer to UNIX the sql loader control file  process the file correctly even though CRLF is for windows

Why?

Comments
Post Details
Added on Mar 16 2019
19 comments
1,388 views