Re: sqlldr

zak.khalid_at_gmail.com wrote:
> I want to concatenate a string to a colum as I load into the table....
>
> so the file will contain apple.1, but when I use sqlldr to load it as
> apple.1_at_net.com
>
> any ideas?

zak.khalid_at_gmail.com wrote:
> I want to concatenate a string to a colum as I load into the table....
>
> so the file will contain apple.1, but when I use sqlldr to load it as
> apple.1_at_net.com
>
> any ideas?

Assuming:

desc t1;

Name                                      Null?    Type
----------------------------------------- -------- ------------

ID                                                 NUMBER
EMAIL                                              VARCHAR2(50)

The following simplified control file shows an example:

load data
infile 'data.csv'
into table t1
fields terminated by ','
(

	id,
	email "concat(:email, '@email.com')"

Note the double-quotes around the SQL function and the colon before the field name, "email".

HTH -g Received on Thu Mar 16 2006 - 10:22:51 CST