Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Loading data in DB from a variety of sources

Loading data in DB from a variety of sources

From: Pinaki <bpinaki123_at_rediffmail.com>
Date: 9 Sep 2003 22:42:30 -0700
Message-ID: <f9f974fc.0309092142.64288e00@posting.google.com>


Hi everybody,

I need to load data into the database(Oracle 9i,Release2,OS-Win2k,Professional) from a variety of sources like .txt,.mdb(Access),.xls(Excel) etc.I have thought of using sqlldr for the job but I have to embed a lot of programming logic depending on which data will be loaded.

     Can I embed programming logic(through PL/SQL) while using sqlldr?Are there any built-in packages which can help me in reading these kind of files and load data in the tables in the database

thanks,
pinaki Received on Wed Sep 10 2003 - 00:42:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US