Re: SQL*Plus formatting question

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.)
Received on Mon Sep 09 2002 - 16:05:56 CDT