Re: Selecting '/n' in query

From: Alex Long <paladin_at_along.dialix.oz.au>
Date: 1995/05/19
Message-ID: <150_at_along.dialix.oz.au>#1/1

 

In article <tim.wyles-190595143521_at_nnsgm844.lon40.nt.com>, Tim Wyles (tim.wyles_at_nt.com) writes:
>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
>

Hi Tim,

Try concatenating CHAR(10) between the columns where you want the L/F character. Here's what I got.

 SQL> SELECT SYSDATE||CHR(10)||SYSDATE FROM DUAL; SYSDATE||CHR(10)||SYSDATE

---

19-MAY-95
19-MAY-95 This worked on a PC (PO7), on some systems you may need to add C/R to the linefeed.

Regards,
Alex Long

--
                          ,     \    /      ,
                         / \    )\__/(     / \   
                        /   \  (_\  /_)   /   \                
 ______________________/_____\__\_at_  @/___/_____\________________ 
|paladin.along.dialix.oz.au 					|
|Alex Long 		   					|		
|Adelaide, South Australia 					|
|_______________________________________________________________|
|Billy, in one of his nice new sashes,         			|
|Fell in the fire and was burnt to ashes;    			|
|Now, although the rom grows chilly,           			|
|I haven't the heart to poke poor Billy.          Harry Graham. |
+_______________________________________________________________+
                   |    /\ /      \\       \ /\    |             
                   |  /   V        ))       V   \  |
                   |/     `       //        '     \|
                   `              V                '
                   
_

Received on Fri May 19 1995 - 00:00:00 CEST