Re: use ltrim with sqlldr
From: Henk Hultink <hhu_at_nospam.stoas.nl>
Date: Thu, 30 Mar 2000 13:43:11 +0200
Message-ID: <38E33DCF.4A2C6822_at_nospam.stoas.nl>
Date: Thu, 30 Mar 2000 13:43:11 +0200
Message-ID: <38E33DCF.4A2C6822_at_nospam.stoas.nl>
Hi,
you can load the specific column as a number-column - provided that it only contains valid numbers. In your control file, specify it as a number column. Oracle will automatically convert it to a number.
gremmelspacher_at_my-deja.com wrote:
> 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 Thu Mar 30 2000 - 13:43:11 CEST