Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Delhi
    Posts
    15

    Question Unanswered: Loading data in the 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

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    If youve got 9ir2 then I would use the external table to load the raw data into staging tables and then use stored procs to transform the raw data into the form you require.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •