non-aligned columns in sqlplus ?
From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 7 Nov 2006 11:37:40 -0800
Message-ID: <1162928260.497242.23850_at_h48g2000cwc.googlegroups.com>
Hello!
[Quoted] (O 9i2)
23;This is a text;2006-08-01
23 ; This is a text ; 2006-08-01
Date: 7 Nov 2006 11:37:40 -0800
Message-ID: <1162928260.497242.23850_at_h48g2000cwc.googlegroups.com>
Hello!
[Quoted] (O 9i2)
[Quoted] 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! Received on Tue Nov 07 2006 - 20:37:40 CET