Skip to Main Content
Forums

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!

Problem with chr(13)||chr(10)

627993Sep 26 2010 — edited Sep 26 2010
Dear All,

I will be really grateful if somebody can address my query as below:

I am using +<string1>chr(13)||chr(10)||<string2>+ to split my string into 2 lines for a text file output.

But sometimes I encounter double quotes at the end of some rows and beginning of some rows. This is not happening to all the output rows, but for some of them.

I am really not able to understand why it is happening.

Could anyone please guide me about this error.

Thanks in advance.

Rollz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2010
Added on Sep 26 2010
#plsql, #sql
5 comments
2,112 views