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!

Martin T. wrote:
select MY_ID || ';' || MY_TEXT || ';' || to_char(MY_DATE, 'yyyy-mm-dd')
from my_table

Gints Plivna
http://www.gplivna.eu

Gints Plivna wrote:
Indeed yes.
Been a bit blind here :-)

thanks!