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

----------------------------------------------------------------------
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

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


Current Time: Thu Mar 28 06:04:46 CDT 2024