Re: Can i upload with conditions in control file (*.ctl)

On 5 mar, 14:30, bdbafh <bdb..._at_gmail.com> wrote:
> On Mar 5, 2:26 pm, chijar <chi..._at_gmail.com> wrote:
>
>
>
> > dear friends.
> > i have a *.dat file with this data:
>
> > 02721511|0601|6|20337358633|41880001|TEXTILES IVLATEX SRL|
>
> > i want to make this:
> > 1.- in third column, the digit is "6" but i want to upload to my table
> > with "09" 'cause it is a varchar2 datatype.
> > so... i can put in ctl file something like that:
> > When third column is 6 then put '09' ???
> > how ?
>
> > 2.- if third column is 1 (integer datatype) i want to upload like
> > '01' (varchar2 datatype)
>
> > it could possible ???
> > how...
>
> > please apologize my english, is not very well.
>
> > Cesar
> > thanks a lot !!!
>
> ETL
>
> (extract, transform, load)
>
> -bdbafh

Please
Could you be more specific?
My question refers with sqqlldr...

thanks a lot Received on Wed Mar 05 2008 - 15:46:59 CST