Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Blank columns in SQL*LDR data file.

Blank columns in SQL*LDR data file.

From: Jason Gonzales <jgonzales_at_plateautel.com>
Date: Thu, 3 May 2001 12:42:18 -0600
Message-ID: <tf3aa73lbr2o80@corp.supernews.com>

I am using SQLLDR to load tab delimited data into an 8.1.7 database. The datafile contains a leading blank column (leading tab) so I've created the destination table with the first column BLANK_COLUMN and then loading the data into this staging table. After the data is loaded into this staging table, I wrote a PL/SQL program to populate the permanent tables. Is there a way to make SQLLDR skip this first colunm during the data load?

Thanks,

Jason Received on Thu May 03 2001 - 13:42:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US