Re: cr/lf with select

From: Dag Arne Matre <dam_at_visma.no>
Date: Thu, 18 Jun 1998 13:14:49 +0200
Message-ID: <3588F6A9.440BC6DC@visma.no>

What about adding cr/lf to the last column or as a separate column of your select?
SELECT BANNER || CHR(13) || CHR (10) FROM V$VERSION or
SELECT BANNER, CHR(13) || CHR (10) AS CRLF FROM V$VERSION D A

Ed Lufker wrote:

> Hi all;
>
> I spool a select to a file , I need to get a cr/lf after every row
> that the select finds. Does anyone have a procedure to do this.
>
> thanks in advance for any help
> eddie lufker
Received on Thu Jun 18 1998 - 06:14:49 CDT