Home » SQL & PL/SQL » SQL & PL/SQL » Import coma seperated text file in to a table ORACLE 10g
Import coma seperated text file in to a table ORACLE 10g [message #185926] Fri, 04 August 2006 05:34 Go to next message
bdpl
Messages: 1
Registered: August 2006
Junior Member
Hello,

Well !! I am new bee with ORACLE, currently my application is built in VB.NET with SQL server,
Now we switched to ORACLE 10g, coming to the point... we have to import coma delimited text file in to
a table via our application, Earlier we were using bulk copy utility ( BCP ) of SQL server, we dont know alternative utility
in ORACLE, Please guy help me out to solve this problem....

Thanks in advance.

bdpl
Re: Import coma seperated text file in to a table ORACLE 10g [message #185927 is a reply to message #185926] Fri, 04 August 2006 05:37 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member


In Oracle We have mainly Two option (Highly recommended )

1. Using SQL * LOADER
2. Using External TABLES .

Just "google" for these ..

Thumbs Up
rajuvan
Re: Import coma seperated text file in to a table ORACLE 10g [message #186014 is a reply to message #185926] Fri, 04 August 2006 14:16 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
... Or check the oracle documentation at

http://tahiti.oracle.com/
Previous Topic: Unable to insert the data..pls
Next Topic: select statement in NVL or decode?
Goto Forum:
  


Current Time: Tue Dec 06 06:40:09 CST 2016

Total time taken to generate the page: 0.16537 seconds