Re: [SQL*Plus] Delimitting with pipe characters is possible?

I am in agreement (I think :) ) ... the problem is we have to assume since the "question" was not really clear.

I also thought "no spaces" was significant.

I suppose/guess the OP could maybe use the TRIM function with colsep and get what they want.

-- 
"Hans Forbrich" <forbrich_at_bad_address.net> wrote in message
news:3FC27A3C.5B16EDF9_at_bad_address.net...


> Burt Peltier wrote:

> >

> > There was a question ? :)

> >

>

> Original request was 'how to change the default SQL*Plus output to use

> '|' between fields'.  The associated example had no spaces between the

> data values and the column separator.

>

> Perhaps a silly assumption, but I thought the lack of spaces around the

> col separator was significant.  Not remembering whether colsep

> suppressed the extra padding, I suggested looking it up.  When Mladen

> bluntly gave the colsep response, I simply asked whether that helps with

> the spacing (but perhaps should have said column separation padding).

>

> <sigh>