Home » Applications » Oracle Fusion Apps & E-Business Suite » Loading data
Loading data [message #321457] Tue, 20 May 2008 05:46 Go to next message
hany_marawan
Messages: 195
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
I have data in text file and I want to load it to my schema to use it my program which is working as a responsibility in the e_business.
I want to build a form to load this data in the database.
How can I do this.
Please I want an example

Thanks
Re: Loading data [message #321522 is a reply to message #321457] Tue, 20 May 2008 10:24 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
use Data loader, for example from http://www.simonhuggins.com/arctan/dataloader/
Re: Loading data [message #321705 is a reply to message #321457] Wed, 21 May 2008 01:59 Go to previous messageGo to next message
hany_marawan
Messages: 195
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Thanks,
But I know the dataloader, but I want it by programming.
Thanks
Re: Loading data [message #322032 is a reply to message #321457] Thu, 22 May 2008 04:19 Go to previous messageGo to next message
lazycat
Messages: 57
Registered: November 2005
Member
sqlloader can help you


thank
Re: Loading data [message #322351 is a reply to message #321457] Fri, 23 May 2008 03:40 Go to previous messageGo to next message
raju_kamarapu
Messages: 19
Registered: February 2008
Location: KAULAMPUR
Junior Member
Use external table concept, u can create external table in procedure and can give the path there.

Re: Loading data [message #322377 is a reply to message #322351] Fri, 23 May 2008 05:17 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Of course, one should pay attention to the fact that external tables weren't available in versions prior to 10g.
Previous Topic: Concurrent Program using SQL * Loader
Next Topic: Adding Supplier organization type
Goto Forum:
  


Current Time: Sun Dec 04 06:53:32 CST 2016

Total time taken to generate the page: 0.07344 seconds