use ltrim with sqlldr
From: <gremmelspacher_at_my-deja.com>
Date: Tue, 28 Mar 2000 14:56:57 GMT
Message-ID: <8bqh7h$ra$1_at_nnrp1.deja.com>
hello,
i like to import some tables with sqlldr into a database. the matter is, that one column of the input data is stored in text-format(align right) but should be imported as number(align left). so i think i have to use a command like ltrim in the ctl-file that the loader can do this work an not me by typing ltrim manually after the data is loaded. thanx
roland
Date: Tue, 28 Mar 2000 14:56:57 GMT
Message-ID: <8bqh7h$ra$1_at_nnrp1.deja.com>
hello,
i like to import some tables with sqlldr into a database. the matter is, that one column of the input data is stored in text-format(align right) but should be imported as number(align left). so i think i have to use a command like ltrim in the ctl-file that the loader can do this work an not me by typing ltrim manually after the data is loaded. thanx
roland
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 28 2000 - 16:56:57 CEST