Home » SQL & PL/SQL » SQL & PL/SQL » how to insert txt file content into my oracle table
how to insert txt file content into my oracle table [message #192953] Thu, 14 September 2006 06:35 Go to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
how to insert .txt file content into my oracle table

I have txt file which contains the data as follows

Maddy1~42~01/05/2006
Maddy2~43~01/05/2006
baddy3~44~01/05/2006
Poddy4~45~01/05/2006
Tridy4~46~01/05/2006
Viddy4~47~01/05/2006

I want to insert these 3 colomns into my table.
Tell me the procedure.

Thanking you.
Re: how to insert txt file content into my oracle table [message #192964 is a reply to message #192953] Thu, 14 September 2006 07:17 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Say please Very Happy

Read up on SQL Loader.

MHE
Re: how to insert txt file content into my oracle table [message #192971 is a reply to message #192953] Thu, 14 September 2006 07:31 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
ya SQL LOADER is the best wayto do it.

Moreover you can also consider using UTL_FILE package in PLSQL, to write your own program which reads data from the file and then insert into the table.

Liza
Re: how to insert txt file content into my oracle table [message #192976 is a reply to message #192971] Thu, 14 September 2006 07:41 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Its a tossup between SQLLDr and External Tables in my view.
If you're defeinitely only ever going to do this import once, then Ldr has the edge, otherwise External tables are pretty much identical as far as time taken goes, and give you more flexibility.
Previous Topic: end-of-file Communication channel
Next Topic: Materialized Views and Fast Refresh
Goto Forum:
  


Current Time: Fri Dec 09 12:00:01 CST 2016

Total time taken to generate the page: 0.10794 seconds