How to skip fields in input file ( SQLLOAD )

I have table:
create table A ( a int, b varchar2 (100) );

My inpu file looks like

1^^abc
1^asd^sbd
1^dd11^123
1^123^123

I need to import first and last fields from the file into columns a,b respectively.

How do I skip second field in the file?

Alex

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 17:29:58 CDT