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!

eliminate space in csv file

user106161Apr 20 2012 — edited Apr 24 2012
Hi

I have a script (see below) which runs and spools the information

select
STU_ID||','||CRSLIST||','||FIRST_NAME||','||SURNAME||','||MID_INITIAL||','||substr(rtrim(STU_ID),-1)||','||STUREF studata
from LOC_STUEMAIL
where STU_ACT = 'A'
order by STU_ID

I spool it to csv file. The STUREF is a number field.
The script does what it is suppose to do. The issue is there are lots of space in the spool file after STUREF field which I want to eliminate. I have tried RTRIM but it is not eliminating them.

Any help please
This post has been answered by hm on Apr 21 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2012
Added on Apr 20 2012
7 comments
3,531 views