Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    2

    Unanswered: 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.

    Thanks

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    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

Posting Permissions

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