Using SQL * Loader [message #72350] |
Sat, 24 May 2003 10:45 |
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 |
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 '"'
|
|
|
|