2 Replies Latest reply on Dec 12, 2013 2:49 PM by Harshal84

    Extra space adding during export from sql developer 3.2

    Harshal84

      Hi,

       

      I'm able to export data from a table using sql developer Gui. I want to implement same process using a query. I'm using below query to perform the process which is saved in export.sql file.

       

      set head off

      SET FEEDBACK OFF

      SET ECHO    OFF

      SET TRIMSPOOL ON

      SET TRIMOUT ON

      spool c:\test.txt

       

      select member_id || ',12' from abc;

      spool off

       

      I execute this file using @c:\export.sql and it does export the file. In my final output, it is also adding extra spaces at the end of each line. Though I'm using TRIMSPOOL in the query statement to avoid extra space, it is unable to prevent it. Has any one faced same issue? Can i export data from sql developer to text file without using GUI?

       

      I'm using sql developer 3.2.