Home » RDBMS Server » Server Administration » Supressing blank spaces
Supressing blank spaces [message #373826] Mon, 14 May 2001 19:19 Go to next message
Tara Kibler
Messages: 2
Registered: May 2001
Junior Member
I want to output a few rows of data from a table to a file. Right now, I'm just spooling a file and doing 'select * from table' and my output file has a ton of blank spaces in it. How do I supress the blank spaces and only get the data in the output file, with each column delimited by something (space, comma, etc.)?

I have tried formatting the columns, changing the linesize, 'trimming' the rows. I don't know what else to try....

Thanks,
Tara

Report message to a moderator

Re: Supressing blank spaces [message #373903 is a reply to message #373826] Wed, 16 May 2001 19:53 Go to previous message
Robert Thibault
Messages: 1
Registered: May 2001
Junior Member
SELECT ' toto',
LTRIM(' toto'), /*left blank*/
RTRIM(' toto '),/*right blank*/
REPLACE(' toto 2',' ', '')/*or all blank*/
FROM dual

Report message to a moderator

Previous Topic: Re: Oracle Query
Next Topic: SQL query syntax
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 17:22:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.