Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to load .csv file into oracle table using TOAD SQL LOADER

kumar73Feb 12 2011 — edited Feb 12 2011
Hello 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2013
Added on Feb 12 2011
6 comments
12,780 views