Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Space issue

724782Feb 16 2012 — edited Feb 17 2012
Hi
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2012
Added on Feb 16 2012
7 comments
496 views