sontents to a csv file

[manjunathk]

Hi guys,
I am trying to spool the contents of a table using a WHERE clause. The table has 22 fields. While the statement executes without any problems, the spooled file shows only values for the first 17 columns.There is data in the last 5 fields too.If I do a simple select, i get all the 22 fields' data.

The same procedure when repeated for another table containing 20 fields, the output in the spool file shows all 20.

Can sombody be able to tell me what may be the problem with the first table?

Thanks
manjunath

[rcaballe]

Maybe if you change the buffer width

[manjunathk]

Thanks Ramon, it worked.
Can you tell me, in sql workshhet, how to go about changing the buffer width?I know in the sql plus, but i am not able to change it in worksheet though.
Thanks again
manjunath

[rcaballe]

I was searching, no luck.
All I can say is that everyone is complaining about Worksheet.
Sorry.

[omegamark]

In 8i you can do export on where clause...
Just try that also once...