Re: SQL*PLUS spooling and CR/LF

From: Prakash V <venkatprakash_at_hotmail.com>
Date: Mon, 23 Aug 1999 20:32:49 GMT
Message-ID: <19990823203249.64148.qmail@hotmail.com>

Just add chr(13) after all the columns. Otherwise u can concatenate chr(13) with the last column u r selecting. For eg

select a,b,chr(13) from your_table;

or

select a,b||chr(13) from your_table;

Hope this will help you

V Prakash

---

Get Your Private, Free Email at http://www.hotmail.com

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Mon Aug 23 1999 - 15:32:49 CDT