Re: SQLLDR syntax question

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 07 Mar 2010 19:54:46 +0100
Message-ID: <4b93f677$0$2888$ba620e4c_at_news.skynet.be>

Martin Frodderrer wrote:
> Hello. This is my first post to this group so if the question is too
> simple, be gentle with me.
>
> I have created a table called test like this "create table test(id1
> number, id2 number)" in Oracle 10g.2 Standard Edition on a Windows XP
> home computer.
>
> I am trying to import data into my "test" table.
>
> My SQLLDR control file looks like this. It is representative of my
> test data but not my test data.
>
> LOAD DATA
> INFILE *
> INTO TABLE test
> REPLACE
> FIELDS TERMINATED BY ','
> OPTIONALLY ENCLOSED BY '"'
> (
> id1 integer external,
> id2 integer external
> )
> BEGINDATA
> 1+9, 400
> "2*10", 401
> 3+8, 402
> 4, 403
> 5, 404
>
>
> When I run SQLLDR, all I get imported into my "test" table is the rows
> with 4,403 and 5,404. I want the additional rows containing
> 10, 400
> 20, 401
> 11, 402
> included in the import too. I can't figure out how to do it.
>
> What I have tried is, in my SQLLDR control file, changing
>
> id1 integer external,
>
> to
>
> id1 integer expression "to_number(:id)",
>
> this doesn't work.
>
> I have also tried
>
> id1 integer expression "select :id1 from dual",
>
> but this doesn't work either.
>
> I am new to this. Can someone help?
>
> Thank you
>
> Martin
>

I think you may have more luck with another tool, but sql*loader is not really suited for this task. Received on Sun Mar 07 2010 - 12:54:46 CST