Updation of RDBMS from a text file

NodeReaper has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Updation of RDBMS from a text file by synapse0 (Pilgrim) on Jul 13, 2001 at 12:38 UTC
DBI.pm is your friend.. Check this out.. http://www.perldoc.com/cpan/DBI.html -Syn0	[reply]
Re: Updation of RDBMS from a text file by agoth (Chaplain) on Jul 13, 2001 at 15:00 UTC
Well your question is improving over time, but is still the same as yesterdays. You've had about 5 pointers to DBI, have you followed them up? and read the DBI::FAQ, because thats what its there for and will show you how to do what you want. Have you actually got a database and a schema? and a table to insert into? Come back with some code that doesnt work..... and then you might get more specific help. Rephrasing the same question and doing no research won't get you very far here.	[reply]
Re: Re: Updation of RDBMS from a text file by synapse0 (Pilgrim) on Jul 13, 2001 at 15:13 UTC
Oh man... I just saw the other instance of this post.. Silly human trying to get others to do the work for him (and not even giving enough info on the project to even tantilize).. this node (which is a repost of a reply to Abigail) really needs to go bybye.. Mr. Nodereaper, your presence is requested. Crazy Joe, go do some homework and stop pestering. -Syn0	[reply]
Re: Updation of RDBMS from a text file by Hofmator (Curate) on Jul 13, 2001 at 14:08 UTC
The database tutorials here at Perl Monks should also help you Reading from a database Tricks with DBI - especially point 3 about placeholders Web Logs Using DBI - not too much your topic but has some more example code -- Hofmator	[reply]
Re: Updation of RDBMS from a text file by aardvark (Pilgrim) on Jul 13, 2001 at 17:04 UTC
I don't know what database you are using, but if it is Oracle, have a look at SQLLoader . It can be very heplful in loading large amounts of data in text files into Oracle. Oracle SQLLoader FAQ Get Strong Together!!	[reply]