From: spamdump@nospam.noway.nohow (Ed Stevens)
Newsgroups: comp.databases.oracle.server
Subject: SQL*Plus formatting question
Date: Mon, 09 Sep 2002 20:28:03 GMT
Organization: IGS Internet News Server (AUSTIN)
Lines: 36
Message-ID: <3d7d02be.6150834@ausnews.austin.ibm.com>
NNTP-Posting-Host: gsine08.us.sine.ibm.com
X-Trace: ausnews.austin.ibm.com 1031603051 23848 9.14.6.48 (9 Sep 2002 20:24:11 GMT)
X-Complaints-To: abuse@ausnews.austin.ibm.com
NNTP-Posting-Date: Mon, 9 Sep 2002 20:24:11 +0000 (UTC)
X-Newsreader: Forte Free Agent 1.21/32.243


Platform:  Oracle 8.1.7 on NT4 or NT2k

Given the following snippet of code:

set echo off
set heading off
 column LOCAL_TRAN_ID format a20 newline 
 column GLOBAL_TRAN_ID format a20 newline 
 column STATE format a20 newline 
 column MIXED format a20 newline 
 column ADVICE format a20 newline 
<snip more of same>

select
 'LOCAL_TRAN_ID: ' || LOCAL_TRAN_ID,                          
 'GLOBAL_TRAN_ID: ' || GLOBAL_TRAN_ID,                         
 'STATE: ' || STATE,                                  
 'MIXED: ' || MIXED,                                  
 'ADVICE: ' || ADVICE,                                 
<snip more of same>

I expect each selected column to report on a separate line, thus:

LOCAL_TRAN_ID: some value
GLOBAL_TRAN_ID: some value
STATE: collecting
MIXED: no  
ADVICE: some value

But what happens is STATE, MIXED, and ADVICE all display on the same line.
Other columns, snipped from this example, do the same.

I know I'm overlooking the obvious, but . . . 
--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)