This discussion is archived
1 Reply Latest reply: Oct 5, 2012 11:22 PM by damorgan RSS

SQLPlus output

965986 Newbie
Currently Being Moderated
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
    damorgan Oracle ACE Director
    Currently Being Moderated
    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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points