右斜杠 java chr,java显示oracel chr（10）

hello every body ...

I''m working on a java-oracle program , I have an oracle function that returns a clob which is the result of appending a group of Strings (of type nvarchar2) ...

in oracle function I''m separating values using CHR(10) to make a new line , check this

''a'' || chr(10) || ''b''

this works in oracle , I mean it looks like

a

b

But in my java application when I retrieve this value returned from oracle function it appears

ab

does anyone have any idea about what to do to make a new line ?

解决方案

What''s your environment?

If it''s windows you''ll need to use ''a'' || chr(13) || chr(10) || ''b''.

chr(13) is carriage return (CR) and chr(10) is linefeed (LF).

In a unix system chr(10) is enough, while on windows you need both CR and LF.

To make it more fun you used just CR on Mac OS up to version 9