Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 4th, 2013, 02:25 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
  #2 (permalink)  
Old November 27th, 2013, 05:15 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Location: Uganda kampala
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by svg3414 View Post
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. :)
  #3 (permalink)  
Old November 27th, 2013, 12:12 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
  #4 (permalink)  
Old December 13th, 2013, 09:42 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert a new line at beginning of text file? how? Satorikin VB.NET 2002/2003 Basics 8 October 15th, 2008 09:55 PM
Most efficient way to insert text into a file StumblingInTheDark Visual Basic 2005 Basics 1 February 22nd, 2007 01:09 PM
Read all rows from text file shai505 C# 5 April 28th, 2006 09:37 PM
how can I insert a new line at top of text file? Satorikin VB.NET 1 March 4th, 2004 03:41 AM
Insert data in a text file and export them cutovoi Excel VBA 3 January 23rd, 2004 07:31 AM



All times are GMT -4. The time now is 11:59 PM.


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