SqlLoader: How to ignore fields?

From: Thorsten Koch <torsti_engy_at_my-deja.com>
Date: Mon, 14 Feb 2000 10:13:04 GMT
Message-ID: <888kfd$8fg$1@nnrp1.deja.com>

Hi folks!

I have a text file that looks something like this: A;B;C
AA;B;CC
A;BBB;CC
AA;BB;CCC
A;B;CC and so on...

No I have a table which only has columns for the A and the C fields, so I want to ignore the second field. I can't use the position parameter, because the field legths are not fixes, only separated by ';'.

Is there a way to tell Oracle what I want?

Greetings,

Thorsten

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 14 2000 - 04:13:04 CST