Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus formatting chaos

Re: SQLPlus formatting chaos

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 11 Jan 2000 15:22:55 GMT
Message-ID: <85fhsf$prb$3@news.seed.net.tw>

Sam Jordan <sjo_at_spin.ch> wrote in message news:3879D882.C28B78FE_at_spin.ch...
> Hi
>
> Oracle 8.0.5 / Linux SuSE 6.0
>
> I am really not an expert concerning SQLPlus, but at least I took
> some time to read the docs concerning output formatting,
> but I can't figure out how to teach SQLPlus to do something very
> basic: just print out everything correctly aligned. Hopefully someone
> can explain how to do this.
>
> Here is what I expect SQLPlus to do:
>
> COLA COLB COLC
> ----------- ----------- -----------------
> abcd efghijkl mnopqrstuvwxyz
> 1234 567890
>
> Here is what SQLPlus usually does here:
>
> COLA COLB COLC
> ----------- ----------- ------------------
> abcd efghijkl mnopqrstuvwxyz
> 1234 567890
>

[snip]

Use:

    set tab off Received on Tue Jan 11 2000 - 09:22:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US