By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

How to export/import the excel file in oracle database using sql promt

P: 34
Dear Sir,
How to export/import the excel file in oracle database using sql promt.

Please guide me the command(export/import) for the neddful.

Thanks in Adavance.

Regards
Sumanta Panda
Jan 15 '09 #1
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
you need to use sql*loader for the purpose.
Jan 15 '09 #2

P: 34
Hi Debasis Bhai,
Thanks for your response.I never used the sql*loader.Could you please
write the command of export/import for excel file in sql*loader.

Thanks in advance.
Regards
Sumanta Panda
Jan 15 '09 #3

debasisdas
Expert 5K+
P: 8,127
please find the details in the following links
link1
link2
link3
link4
Jan 15 '09 #4

P: 34
Thank you Debasis Bhai.
Jan 16 '09 #5

debasisdas
Expert 5K+
P: 8,127
You are most welcome sumanta.

I hope that solved your problem of data loading from flat files.
Jan 17 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.