p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   How to insert rows from a text file. (http://p2p.wrox.com/showthread.php?t=91429)

svg3414 November 4th, 2013 02:25 PM

How to insert rows from a text file.
 
Hi,

I would like to know a fast method to insert a large number of rows from a text file to an Oracle table. The text file is on the client machine whereas the table is on the server.

muteesa November 27th, 2013 05:15 AM

Quote:

Originally Posted by svg3414 (Post 294536)
Hi,

I would like to know a fast method to insert a large number of rows from a text file to an Oracle table. The text file is on the client machine whereas the table is on the server.

Hi,
I think python/php can give a quick method of capturing all the text records into a multidimmention list, then read the records and insert them into the oracle database.
you need to be sure that the records in the text file match your table columns. you can split the text file records at spaces.
hope this helps you. :)

svg3414 November 27th, 2013 12:12 PM

Thanx muteesa.

But I know nothing about python or php.

I know a bit of PL/SQL. Would like to know if a procedure / package written in PL/SQL can speed up the insertion.

cka4206 December 13th, 2013 09:42 AM

Is the text file's content comma separated or space separated?
You can import a formated text file to oracle db using import utility.

Or you can use MS Access to create a link table in your oracle db and then import the text file to this link table from MS Access.


All times are GMT -4. The time now is 03:41 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.