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