Re: Oracle spool formatting fields "wrong"
Date: Fri, 15 Dec 2006 17:22:13 +0100
Message-ID: <4582cbb5$0$26358$426a34cc_at_news.free.fr>
[Quoted] <mr.jawright_at_gmail.com> a écrit dans le message de news: 1166198943.108769.284550_at_79g2000cws.googlegroups.com...
|I am trying to fix a spool of the results of a query into a text file.
| On one of my databases this works as expected, but on another the
| formatting is not correct.
|
| I am including a section of the output, but the problem may be hard to
| see.
| The first seven columns (120 bytes) are formatted correctly, but every
| field after the first seven is on a new line.
| Does anyone have an idea what would cause this?
|
| thanks
|
SQL> column "ASN_Count" format a6 heading 'x' -- 0 to 10000 SP2-0158: unknown COLUMN option "--"
The column statement starting with the heighth are not taken by SQL*Plus.
Regards
Michel Cadot
Received on Fri Dec 15 2006 - 17:22:13 CET