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!

CR LF at the end of each new line Utl_file

968361May 19 2014 — edited May 19 2014

Hi,

My database server resides on Unix platform. 

I am writing a piece of code to write some data into file using UTL_FILE. After writing i am trying to open it into windows. But the problem is that each line end with CR LF when i try to open it into windows Notepad ++ .

e.g

test to write fine line1 CR LF

test to write fine line2 CR LF

test to write fine line3 CR LF

I want only LF should  be displayed.

test to write fine line1 LF

test to write fine line2 LF

test to write fine line3 LF

Can you please suggest me any approach? Or is it like in windows all the line wil be terminated with CR LF?

regards

-vinod

This post has been answered by SKP on May 19 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2014
Added on May 19 2014
14 comments
2,080 views