Re: Loading data in DB from a variety of sources

From: vipan <dba_at_no_spam.netscape.net>
Date: Wed, 10 Sep 2003 12:32:19 +0530
Message-ID: <3F5ECC7B.4090106@no_spam.netscape.net>

Hi,

For this task, i would suggest the use of external tables which is new feature of oracle9i. You just have to create some external tables which will be linked to flat file and on that external table you can right any

sort of pl/sql program.
For details please go through this artical.. http://www.dbasupport.com/oracle/ora9i/External_Tables9i.shtml

Thanks

Pinaki wrote:
> 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 - 02:02:19 CDT