Re: Selecting '/n' in query

tim.wyles_at_nt.com (Tim Wyles) wrote:

>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 ?????? ?

You may try the following:

select sysdate||chr(10)||sysdate
from dual;

Gerard (gverhage_at_xs4all.nl) Received on Sat May 20 1995 - 00:00:00 CEST