DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2000
    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?


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

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

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

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

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.