Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Loading data in DB from a variety of sources
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
![]() |
![]() |