Re: Selecting '/n' in query
From: Gary Wong <gwong_at_idirect.com>
Date: 1995/05/19
Message-ID: <Edda1995May19.171813.27685_at_news.compulink.com>#1/1
Date: 1995/05/19
Message-ID: <Edda1995May19.171813.27685_at_news.compulink.com>#1/1
In article <tim.wyles-190595143521_at_nnsgm844.lon40.nt.com>,
tim.wyles_at_nt.com says...
>
>I'm having difficulty in selecting a newline value in a query. Using a
>simple example, I wish to use something to like
>
> select sysdate, ??????, sysdate from dual;
>
>with the result that each sysdate is on a newline, directly under the
>other. What should I put in place of ?????? ?
>
>Thanks
>
>Tim
>
>***
>Standard blah-blah disclaimer...
>***
Try this
SELECT SYSDATE,'
',SYSDATE FROM DUAL;
The 2 quote makes are suppose to be on different lines.
Gary Wong
gwong_at_idirect.com
Toronto
Received on Fri May 19 1995 - 00:00:00 CEST