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

Home -> Community -> Usenet -> c.d.o.misc -> Re: formatting output with SQL*Plus

Re: formatting output with SQL*Plus

From: Alan <alan_at_erols.com>
Date: Wed, 8 Dec 2004 15:28:08 -0500
Message-ID: <31p6epF3eaf54U1@individual.net>

"Thomas Kellerer" <NNGNVRDSJEBN_at_spammotel.com> wrote in message news:cp7kmh$l1u$1_at_svr7.m-online.net...
> Alan wrote on 08.12.2004 20:22:
> >
> > SELECT column1||'|'||column2 etc...
> >
> > Get rid of SET COLSEP
> >
>
> As I have already pointed out in my original post: I get the following
> error when doing so:
> "ORA-01489: result of string concatenation is too long"
>
> Thanks
> Thomas

Sorry, missed that. This probably won't help you, but when I run into this, I have used the following solutions:

  1. I take the results as they are, paste it into Word or Excel, and just find/replace <space><space> with <space> until it's done. I suppose you could use vi to do the same.
  2. I'll use a 3rd party tool, such as Cognos Impromptu or Lotus Approach.
  3. I get one of the COBOL programmers to process it for me.

Maybe someone knows the "right" way. Received on Wed Dec 08 2004 - 14:28:08 CST

Original text of this message

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