Space issue
724782Feb 16 2012 — edited Feb 17 2012Hi
I am writing some data from oracle to Unix file. I have to pad spaces to the end of the line to make the length of each record uniform.
I am using lpad(' ',10,' ') to append the space to the end of each record. when i tried this in SQL developer it worked fine and gave the space at the end of the line.
the problem is that when i am redirecting the output to a unix file it is not appending the space at the end of the line.
Any quick help greately appreciated.