1 Reply Latest reply on Oct 6, 2012 6:22 AM by damorgan

    SQLPlus output

      I need to output from sqlplus to a variable width text file. I set the linesize then (SET Trimout ON) to elieinate the spaces. but I have some lines which data has leading spaces and I need them to appear. If i "SET Trimout OFF" then all lines will have the unwanted space?
      How do I Trim extra space at the end of rows but do not trim the space that comes from select statement ?

      Edited by: user4981578 on Oct 4, 2012 1:56 PM
        • 1. Re: SQLPlus output
          The name of this forum is Oracle Clusterware. If you can explain how your question, in any manner, relates to Clusterware ... I will answer it here. But to be honest ... I don't even know how SQL*Plus relates to Clusterware.

          Otherwise please close this thread. Thank you.