Re: How to skip fields in input file ( SQLLOAD )

See Thomas Kytes posting from about 3 weeks ago or search deja news, he created a package called Delimit.

M

arivlin_at_my-deja.com wrote in message <7jk5gp$2fv$1_at_nnrp1.deja.com>...
>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 Wed Jun 09 1999 - 02:52:22 CDT