Re: line breaks

From: <twod_at_not.valid>
Date: 1997/11/22
Message-ID: <655du3$9h8$1@vnetnews.value.net>#1/1

David Turner (turner_at_vortex.more.net) wrote:
: select 'Hello World' from dual;
: When using sqlplus?
: The line break should be between Hello and World.

Under *nix where 10 is the decimal for NL :-

SELECT 'Hello' || chr(10) || 'World' FROM dual;

IAP

--
You have mistakenly entered section 26 of disinformation superhighway 9.
Monitored by Main F[ao]rce Patrol. Fatalities this year = 57. Leave now.
I am using anti-spam measures, please replace 'not.valid' with 'value.net'

Received on Sat Nov 22 1997 - 00:00:00 CST