Re: Flat file, non-fixed column dump of SELECT?
From: Mike Accetta <mja_at_cs.cmu.edu>
Date: 28 Oct 1999 18:54:30 GMT
Message-ID: <7va656$gm3$1_at_goldenapple.srv.cs.cmu.edu>
Date: 28 Oct 1999 18:54:30 GMT
Message-ID: <7va656$gm3$1_at_goldenapple.srv.cs.cmu.edu>
[Quoted] In article <7v1jg2$ecd$1_at_news6.svr.pol.co.uk>, Simon Hedges <shedges_at_hhhh.freeserve.co.uk> wrote:
>
>SELECT COLUMNA||','||COLUMNB
>FROM YOURTABLE;
>
>This should do it. Don't forget to TO_CHAR any
>number or date columns.
Yes, that's what I was looking for. Thanks!
I didn't seem to need TO_CHAR around the number columns for what that's [Quoted] worth. Line width was still padded out but I can cope with that better than every column being padded. Received on Thu Oct 28 1999 - 20:54:30 CEST