Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Blank columns in SQL*LDR data file.
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
![]() |
![]() |