Home » SQL & PL/SQL » SQL & PL/SQL » PL/Sqlplus-extracting data from Table to comma delim file
PL/Sqlplus-extracting data from Table to comma delim file [message #833] Thu, 07 March 2002 07:39 Go to next message
Johnson
Messages: 5
Registered: February 2002
Junior Member
Hi,
Thanks for your help in advance. I'll try to keep it short.

I'm trying to extract data from a table into a comma delimited file using Sql/SqlPlus. I've written the sql and spool it to a file. This works ok, where the problem comes in is that I have to set a linesize so long that the file becomes very big. I would like to remove these "extra" spaces at the end of each line. Each line varies in length as is with a delimited file.

Is there a diff. approach I should be taking? I don't have any 3rd party software to work with only Pl/SQL, Sql,Plus.

Thanks

Report message to a moderator

Re: PL/Sqlplus-extracting data from Table to comma delim file [message #836 is a reply to message #833] Thu, 07 March 2002 09:35 Go to previous message
migel
Messages: 4
Registered: February 2002
Junior Member
Set trimspool on.
Will remove any spaces at end of line. You still need to set a linesize value.

HTH

Report message to a moderator

Previous Topic: Line number in SQL
Next Topic: optimized count
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 06:01:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.