SQL Loader to load FA data into Oracle

[prema]

Hi everybody

has anybody used SQL Loader to load data into Oracle
if yes, can you please send me a stepwise procedure of how to do it

thanks
prema

[siva sankar]

Hi Prema,

When we uploading the data from flat file to Oracle tables.
we can use the SQL*LODER to upload the date from flat file to oracle.

1)First we Receive the flat file from the client(Formats like .txt,.dat,.csv)
2)We prepare the Control File.

Syntax:

LOAD DATA
INFILE "data file path"
INSERT INTO table_name
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED By " "

START---> RUN---> cmd

SQLLDR=Control file path

IF any error occur in this..

If you are facing any problem regarding this please let me know..

[jscrunch]

Hello,
here you have a goog link:
http://orafaq.com/wiki/SQL*Loader#Conditional_Load

Hope it helps,
Jose L.