X-Trace-PostClient-IP: 24.84.134.54
Message-ID: <3D7D0BAC.E663E6E1@shaw.ca>
From: Bricklen <bricklen@shaw.ca>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: SQL*Plus formatting question
References: <3d7d02be.6150834@ausnews.austin.ibm.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 51
Date: Mon, 09 Sep 2002 21:05:56 GMT
NNTP-Posting-Host: 24.64.223.206
X-Complaints-To: abuse@shaw.ca
X-Trace: news2.calgary.shaw.ca 1031605556 24.64.223.206 (Mon, 09 Sep 2002 15:05:56 MDT)
NNTP-Posting-Date: Mon, 09 Sep 2002 15:05:56 MDT
Organization: Shaw Residential Internet


Try this:

select
'LOCAL_TRAN_ID: ' || LOCAL_TRAN_ID||chr(10)||
'GLOBAL_TRAN_ID: ' || GLOBAL_TRAN_ID||chr(10)||
'STATE: ' || STATE||chr(10)||
'MIXED: ' || MIXED||chr(10)||
'ADVICE: ' || ADVICE||chr(10)|| ... from ...


hth
Bricklen

Ed Stevens wrote:
> 
> 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.)