Parsing a tab delimited text fileinto Oracle database

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

Hello everyone, I am new to this forum.Can anyone please help me in parsing a tab delimited data file in to Oracle database.My file contains plenty of columns and rows. If not please let me know how can I parse the excel spreadsheets into oracle database. Thanks a lot in advance sridhar

Comment on Parsing a tab delimited text fileinto Oracle database

Replies are listed 'Best First'.
Re: Parsing a tab delimited text fileinto Oracle database by marto (Cardinal) on Jul 13, 2010 at 18:37 UTC
For a perl solution see DBI and DBD::Oracle. A non perl solution would be sqllrd If you're new to perl see the tutorials section (including Getting Started with Perl and Database Programming) of this site, and http://learn.perl.org.	[reply]
Re: Parsing a tab delimited text fileinto Oracle database by Anonymous Monk on Dec 01, 2011 at 13:32 UTC
See Re: Open multiple file handles?, DBIx::TableLoader::CSV, DBD::AnyData, site:perlmonks.org xsv DBI -> Comparison of the parsing features of CSV (and xSV) modules, Creating Table and Inserting Data from CSV I'm sure there are more threads/examples, it is the epitomy of a Frequently Asked Question	[reply]