Hi, I want to insert a carriage return in one field, and I don't know how to perform this.

I tried
Code:
insert into test1 values('line1' || char(13) || 'line2');
insert into test1 values('line1\r\nline2');
insert into test1 values('line1#10#13line2');
and none work

How do you insert escape chars in your queries ?

thanks in advance