Home » RDBMS Server » Server Utilities » Exporting delimited data
Exporting delimited data [message #69077] Wed, 24 October 2001 18:21 Go to next message
Henning
Messages: 6
Registered: October 2001
Junior Member
I am currently spooling data to a textfile.

The output is keeping the blank spaces to fill out a full field.

eg name field is varchar2(25) and city is varchar2(20).
the output is Peter and Copenhagen.

My output is currently
Peter |Copenhagen |

I would like it like this
Peter|Copenhagen|

Any suggestions would be welcome

Henning

----------------------------------------------------------------------

Report message to a moderator

Re: Exporting delimited data [message #69078 is a reply to message #69077] Thu, 25 October 2001 01:01 Go to previous message
Sirajdin
Messages: 17
Registered: May 2001
Junior Member
Use CONCAT or ||

hth

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Script for compiling all packages
Next Topic: ORA-12560:TNS:protocol adapter error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 14:12:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.