Re: Oracle spool formatting fields "wrong"

From: Michel Cadot <micadot{at}altern{dot}org>
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

Original text of this message