trim off the write space
I have a question on the trimming off the extra white space.
SET LINESIZE 300
f1 f2 f3
ccccc < THERE are SOME big white space here >
fffff < There are Some big white space here >
What is the best way to remove off the big white space ?
what the heck are those aaa bbb ccc? columns or what?
if I write
f1 f2 f3
in sqlplus prompt I will get error so I am not sure what you are talking about
Sorry for unclear question,
actually the aaaa,bbbb,cccc is already spool to a file format then I want it to be output into the vertical format for each record.
That's why, after each field I concat with the CHR(13) but not the last column of the field. The last column always embeded some whitespace.
Anyway, I solved the problem using SET TRIMSPOOL ON before run the script.
Thanks for the feedback
Click Here to Expand Forum to Full Width