Brian Tkatch wrote:
> 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)
No - your display simply is not wide enough.
Why don't you check out all possible settings in SQL*Plus?
the one you want is SET LINES[ize]
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Nov 21 2007 - 12:48:11 CST
