Spooling variable length records

From: Jason Selby <jselby_at_cams.co.uk>
Date: 1998/01/22
Message-ID: <CMS96242CDFD@cams.demon.co.uk>#1/1

Here's the thing, I have an aplication which needs to output variable length ASCII text files from ORACLE tables.

To do this I use SQLPLUS and have a script which does something like

set heading off
set feedback off
etc
set linesize 200
spool file1.txt
select field1||'|'||field2 etc..
from tab1;
spool off

My problem is that most of the files I create have variable length records which means that each record has a load of trailing spaces on it. This has to be stripped off by a seperate routine.

Is there any way to get ORACLE to output an ASCII file and trim off extra spaces at the same time.

Many thanks

Jason Received on Thu Jan 22 1998 - 00:00:00 CST