Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus formatting question
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_at_sybrandb.demon.nl> wrote in message
news:unq7vgh34irobc_at_corp.supernews.com...
>
> "Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message
> news: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.)
>
> IIRC it's new_line (or fold after)
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Mon Sep 09 2002 - 20:00:01 CDT