Home » SQL & PL/SQL » SQL & PL/SQL » chr(10) chr(13)
chr(10) chr(13) [message #10731] Thu, 12 February 2004 09:35 Go to next message
Scion78
Messages: 15
Registered: February 2004
Junior Member
v_msg_usr = 'some text';
v_msg_usr1 = 'some text';

v_msg_usr || chr(10) || v_msg_usr1 || ' Your administrator(s) are: '|| chr(10) || chr(13);

I want that after v_msg_usr there should be a carriage return. and after 'Your Administrators are: ' there should be carriage return and new line. The carriage return and new line work together but for some reason the chr(10) doesnt produce a carriage return and the strings appear on the same line.

Any help would be appreciated.
Thanks
Re: chr(10) chr(13) [message #11744 is a reply to message #10731] Sun, 11 April 2004 15:52 Go to previous message
matin
Messages: 1
Registered: April 2004
Junior Member
what work is done by chr(10) and chr(13)
Previous Topic: List tables I own
Next Topic: reading only 1 field value from ref cursor
Goto Forum:
  


Current Time: Fri Apr 26 09:13:21 CDT 2024