SQL*Loader and skipping data

From: <kpatric2_at_csc.com>
Date: Fri, 21 Aug 1998 21:13:54 GMT
Message-ID: <6rknui$eba$1_at_nnrp1.dejanews.com>

Here is my problem: I have data fields of varying lengths, delimited by commas:

"1234", "Name1", "Owner", "`24jkflsafd"
"23", "AnotherName", "User", "fjfk;"

what I want to do is place the third field only into a table. Every way I can find to do something along those lines typically use absolute POSITION or require all the fields to be read into the DB. What I would ideally like to be able to do is to say something along the lines of:

INTO TABLE emp
(ROLE POSITION(third field))

Big question is how to say "third field" to SQL*Loader without going through first and second.

rkp

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 21 1998 - 23:13:54 CEST