Home » SQL & PL/SQL » SQL & PL/SQL » Data upload
Data upload [message #421500] Tue, 08 September 2009 15:00 Go to next message
sirajuddin
Messages: 6
Registered: September 2009
Location: PAKISTAN
Junior Member
Hi friends
anybody knows how to insert data in orale table from Excel File and how many type to import data and how? hope you will help me
regards this. thanks

Regards,.........Siraj
Re: Data upload [message #421505 is a reply to message #421500] Tue, 08 September 2009 17:19 Go to previous messageGo to next message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Save as CSV, load with SQLLoader
Re: Data upload [message #421510 is a reply to message #421505] Tue, 08 September 2009 23:39 Go to previous messageGo to next message
Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai
Member

Can also use External Tables ( convert excel into csv)
or can use UTL_PKG ( convert excel into csv)

Regards
Prajakta
Re: Data upload [message #421512 is a reply to message #421500] Tue, 08 September 2009 23:47 Go to previous message
BlackSwan
Messages: 24906
Registered: January 2009
Senior Member
>Can also use External Tables ( convert excel into csv)
>or can use UTL_PKG ( convert excel into csv)

What is URL to documentation or working example for either/both?
Previous Topic: on check constraints...
Next Topic: Problem in Bursting Engine, Oracle R12
Goto Forum:
  


Current Time: Mon Sep 26 23:11:42 CDT 2016

Total time taken to generate the page: 0.17478 seconds