Re: SQL*PLUS spooling and CR/LF

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 23 Aug 1999 12:12:29 -0400
Message-ID: <37C172ED.8A528142@Unforgettable.com>

What is your OS? If it is UNIX and you are transferring the file to a DOS/Windows box then you need to use FTP and transfer the file as ASCII.

If that isn't your sceanrio, please post more details so we can spot the problem.

Ken

abrusko wrote:

> Does anyone know how I can place a carriage return/line
> feed at the end of each row of data that I spool from a
> "select" in SQL*PLUS.
>
> I am creating a comma-delimited file by spooling the data,
> but I need to have a CR/LF at the end of each record. The
> "select" statement doesn't seem to do this naturally when
> spooling to a text file.
>
> Does anyone know how to place a CR/LF at the end of each
> line of sppoled data?
>
> Thanks alot for your help!
> Andy
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Mon Aug 23 1999 - 11:12:29 CDT