Skipping columns with SQLLDR

From: Wayne S Bellefeuille <wbellefe_at_allina.com>
Date: Mon, 02 Oct 2000 08:33:06 -0500
Message-Id: <10637.118315@fatcity.com>

Okay, so what am I missing here?

I want to be able to use SQLLDR to load a tab-delimited file into a table, but the tab-delimited file has extra columns in it that I don't want to use. How can I build a control file to skip these extra columns in the file?

What would the control file be for the following example: Table:
CREATE TABLE wayne
(col_a VARCHAR2(20),
col_b VARCHAR2(20));

Flat file (tab-delimited):
junk<TAB>col_a data<TAB>junk<TAB>junk<TAB>col_b data<TAB><TAB>

Note that I cannot simply use positional columns here, since the length of each flat-file column is variable.

Is my only choice to clean up the flat file to get rid of the "junk" columns? Received on Mon Oct 02 2000 - 08:33:06 CDT