Re: use ltrim with sqlldr

LOAD DATA
INFILE *
REPLACE
INTO TABLE XXX
(
FIELD_A "LTRIM(:FIELD_A)",
FIELD_B,
)
BEGINDATA
      Right aligned data,nextvalue

Simple supply the function to sql*loader it will apply this before inserting the data.
Brett.

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 Tue Apr 11 2000 - 03:01:00 CEST