Re: non-aligned columns in sqlplus ?
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 7 Nov 2006 13:08:18 -0800
Message-ID: <1162933698.197835.80260_at_h48g2000cwc.googlegroups.com>
Date: 7 Nov 2006 13:08:18 -0800
Message-ID: <1162933698.197835.80260_at_h48g2000cwc.googlegroups.com>
Martin T. wrote:
> Hello!
> (O 9i2)
>
> Is it possible with SQLPlus to produce output without any aligning of
> the columns.
> I only found I can change the column separator char, but this wont help
> me dump some data to a text file if everything get's padded up.
>
> So is it possible to produce
> MY_ID;MY_TEXT;MY_DATE
> -------------------------
> 23;This is a text;2006-08-01
>
> instead of
> MY_ID ; MY_TEXT ; MY_DATE
> -------------------------
> 23 ; This is a text ; 2006-08-01
>
> ?
>
> Thanks!
select MY_ID || ';' || MY_TEXT || ';' || to_char(MY_DATE, 'yyyy-mm-dd') from my_table
Gints Plivna
http://www.gplivna.eu
Received on Tue Nov 07 2006 - 22:08:18 CET