How to load .csv file into oracle table using TOAD SQL LOADER
kumar73Feb 12 2011 — edited Feb 12 2011Hello Friends,
I have .CSV file ( Comma seperated values ) file .
I want to load into oracle table .
Can any one suggest how to load this .csv file into oracle table using TOAD .
Appreciate your help.
I tried using TOAD ( using use existing control file option ) but am getting error ..
==========
SQL*Loader-350:
Syntax error at line 5.
Expecting quoted string, found "(".
fields terminated by (',')
^
Loader is finished
==============
The control file I created is as follows ..
load data
infile ModifiedBeforeQADrop_10000records_FINANCIAL_ADVISOR_X_ACCOUNT.csv
insert into
into table temp_faxa
fields terminated by (',')
Thanks./kumar