Re: non-aligned columns in sqlplus ?

Gints Plivna wrote:
> 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
>

Indeed yes.
Been a bit blind here :-)

thanks! Received on Wed Nov 08 2006 - 08:09:18 CET