Re: SQL*Plus formatting question

Because of the concatenation the column names changed. You did not see that because you set heading off (try once with set heading on). So alias the column names and format that alias name with the column command. Example:

colum COL1 format a20 newline

SELECT 'local_tran_id'||local_tran_id col1 , ........

Ed Stevens <spamdump_at_nospam.noway.nohow> schreef in berichtnieuws 3d7d02be.6150834_at_ausnews.austin.ibm.com...
| 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:13:52 CDT