Home » RDBMS Server » Server Utilities » Using SQL * Loader
Using SQL * Loader [message #72350] Sat, 24 May 2003 10:45 Go to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Dear Experts,

Using SQL * Loader.

Kindly tell me how to write script from SQL> to Export and generate CSV file.

And at the same time please give scrip to Import CSV file from SQL> prompt.

I will be very thankful.

Regards,
Syed Muzzammil
Re: Using SQL * Loader [message #72352 is a reply to message #72350] Sun, 25 May 2003 22:46 Go to previous messageGo to next message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
Use Oracle Documentation for help about SQL * LOADER. Correct syntax you can get it from there. All you have to write in control file
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
Re: Using SQL * Loader [message #72407 is a reply to message #72350] Mon, 09 June 2003 12:28 Go to previous message
Kaushal Desai
Messages: 1
Registered: June 2003
Junior Member
How can I avoid duplicate values (DATA) in to SQL*LOADER?
Previous Topic: Email from a stored procedure
Next Topic: I know this might sound stupid...but
Goto Forum:
  


Current Time: Tue Dec 24 07:57:05 CST 2024