Re: NewLine with SQL

From: Galen Boyer <galendboyer_at_yahoo.com>
Date: 2 Oct 2001 15:53:09 -0500
Message-ID: <upu85r48a.fsf@verizon.net>

On 2 Oct 2001, tkyte_at_us.oracle.com wrote:

> use chr(10) which is the linefeed character (newline).
> chr(13)||chr(10) on DOS (but char(10) typically does it just as
> well)

I'll be damned.

I just tried it.

SQL> select 'hello' || chr(10) || 'goodbye' from dual;

'HELLO'||CHR(

---

hello
goodbye

Had no idea. That would have come in useful a few times awhile back. Makes my idea a whole bunch of needless work.

-- 
Galen Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Tue Oct 02 2001 - 15:53:09 CDT