From: "Michael J. Moore" <hicamel_x_the_spam@attbi.com>
Newsgroups: comp.databases.oracle.server
References: <3d7d02be.6150834@ausnews.austin.ibm.com> <unq7vgh34irobc@corp.supernews.com>
Subject: Re: SQL*Plus formatting question
Lines: 94
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <lubf9.264375$aA.45782@sccrnsc02>
NNTP-Posting-Host: 12.234.158.148
X-Complaints-To: abuse@attbi.com
X-Trace: sccrnsc02 1031619601 12.234.158.148 (Tue, 10 Sep 2002 01:00:01 GMT)
NNTP-Posting-Date: Tue, 10 Sep 2002 01:00:01 GMT
Organization: AT&T Broadband
Date: Tue, 10 Sep 2002 01:00:01 GMT


COL[UMN] [{column|expr} [option ...]]

where option represents one of the following clauses:

ALI[AS] alias

CLE[AR]

ENTMAP {ON|OFF}

FOLD_A[FTER]

FOLD_B[EFORE]

FOR[MAT] format

HEA[DING] text

JUS[TIFY] {L[EFT]|C[ENTER]|C[ENTRE]|R[IGHT]}

LIKE {expr|alias}

NEWL[INE]

NEW_V[ALUE] variable

NOPRI[NT]|PRI[NT]

NUL[L] text

OLD_V[ALUE] variable

ON|OFF

WRA[PPED]|WOR[D_WRAPPED]|TRU[NCATED]

"Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message
news:unq7vgh34irobc@corp.supernews.com...
>
> "Ed Stevens" <spamdump@nospam.noway.nohow> wrote in message
> news:3d7d02be.6150834@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.)
>
> IIRC it's new_line (or fold after)
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>