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!

Carriage Return not working

929709Apr 10 2012 — edited Apr 10 2012

I am using sql developer 3.1.0.7 and when i run a select with carriage return and/or line feed the results do not display correctly, but when i run the same select statement in sql plus it works??? Can someone help me fix this please?

eg. select 'a' || chr(13)||chr(10) || 'b' from dual;

thanks,
wayne

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2012

Added on Apr 10 2012

4 comments

540 views