Re: Adding semicolon between columns in SQL*ReportWriter and SQL*Plus

> Holger.Eklund_at_sva.se (Holger Eklund) writes:
> Can any one please tell me how to insert a semicolon between retrieved
> columns in SQL*Reportwriter or a Sqlplus script. My intention is to
> replace the normal delimiter space with a semicolon in the query
> result and thereby easyer be able to read it up in Excell/Access etc.
>
> ( I realize that it's possible to make concat with ; in the query but
> there must be an another and simpler way of doing this without
> rewriting all of my reports end plus scripts )
>
>
>
>
>>>>
That rewrite may be easier than you think. It looks to me like all you need is a global substitution of --> ||';'|| <-- for --> , <-- in your SELECT commands, which would be easy to do with a WORD6 macro for example.

• Paul de Anguera, City of Seattle/HRIS