SQLLDR table column->excel column mapping
708091Jul 14 2011 — edited Jul 16 2011CREATE TABLE "DW"."ABC"
( "SKILL_NAME" VARCHAR2(60 BYTE) NOT NULL ENABLE,
"SKILL_TYPE" VARCHAR2(20 BYTE),
"DAILY_DATE" DATE NOT NULL ENABLE,
"SCC_NAME" VARCHAR2(60 BYTE),
"RFS_FORECAST" NUMBER(8,0),
"FORECASTED_CALLS" NUMBER(8,0),
"TOTAL_CALLS_ANSWERED" NUMBER(8,0)
) ;
This is a table.
FOllowing are excel columns
Date RFS Forecast FORECASTED CALLS TOTAL CALLS ANSWERED
Control file is the following
load data
CHARACTERSET UTF16
infile 'D:\CSVs\4cols.csv'
into table
"ABC"
fields terminated by "," optionally enclosed by '"'
(
SKILL_NAME CONSTANT 'FM',
SKILL_TYPE CONSTANT 'CLIENT',
DAILY_DATE,
SCC_NAME CONSTANT NULL,
RFS_FORECAST,
FORECASTED_CALLS,
TOTAL_CALLS_ANSWERED)
how to associate the table columns with excel columns.....
and if the first row of the excel is the header how to specify that