PL/Sqlplus-extracting data from Table to comma delim file

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.

ThanksHello,

I hope I understand what you want to do ... you just want to trim the
line and kick off the blancs at eatch end of line ?

if so TRIM is the command you need ...

Hope this helps ?

Greetings

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

pivot table

I'm trying to extract some data from an ssas 2005 cube to build a report with ssrs 2005.

The report should have a variable number of columns and a fixed number of rows ... so I think I cannot use a table control but I must use a matrix control ...

So I would group the column for the fiscal month and the row for the measure name or measure caption ... and put the measure value inside the matrix.

Like the following

month 1 month 2 measure 1 xxx xxx measure 2 xxx xxx measure 3 xxx xxx

To do that I should run a query to extract data in the following form ...

fiscal month mesaure name measure value month 1 measure 1 xxx month 1 measure 2 xxx month 1 measure 3 xxx month 2 measure 1 xxx month 2 measure 2 xxx month 2 measure 3 xxx

The problem is ... when running an mdx query on reporting services I need to put the meausure only on the columns ...

so any idea on how can I extract data from ssas in that form ?

Cosimo

Can you place an upper bound on the number of months you need to report? Also, how do you want your months to display from left to right -- most recent to least recent?|||

thank

I solved ... using a static group and a matrix control

Cosimo