Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Spool file - Triming columns

Spool file - Triming columns

From: Matthieu <Matt_at_nospam.fr>
Date: Mon, 29 Nov 2004 10:13:26 +0100
Message-ID: <coenja$mjl$1@reader1.imaginet.fr> 





Hello,



I want to make an extraction into a flat file of the folowing table:



ART




CO_ART VARCHAR(12)
LI_ART VARCHAR(50)
CO_MOD NUMBER(1)





I want the flat file looks like:



1529#PRODUCT 1#1



1254899#PRODUCT 2222#1



12#PROD 1235#2


I use set COLSEP '#' for the separator but how can I make my columns trimed.
By default it looks like:


1529              #PRODUCT 1                          #1
1254899        #PRODUCT 2222                    #1
12                  #PROD 1235                            #2





Thanks for help.



Matthieu
Received on Mon Nov 29 2004 - 03:13:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US