Does CHR(10) add an extra newline?

While writing a query to do some editting i wanted to use CHR(10) to have a query do some formatting. It seems that whenever it is used, it adds an extra newline at the end of the line.

SQL> SELECT RowNum A, CHR(10) || RowNum B FROM (SELECT * FROM Dual CONNECT BY LEVEL < 4)

         A B

---------- -----------------------------------------
         1
           1

         2
           2

         3
           3

3 rows selected.

SQL> How do i add a newline in middle of a line without adding at the end as well?

B. Received on Wed Nov 21 2007 - 11:06:01 CST