DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: sontents to a csv file

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    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

  2. #2
    Maybe if you change the buffer width
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    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

  4. #4
    I was searching, no luck.
    All I can say is that everyone is complaining about Worksheet.
    Sorry.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  5. #5
    Join Date
    Sep 2000
    Posts
    384
    In 8i you can do export on where clause...
    Just try that also once...
    Radhakrishnan.M

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width