Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Bucharest, Romania

    Unhappy Unanswered: how do i get data from a text file to insert into a table?

    I have a text file with many fields and i want to insert that data into a table in Oracle 9i. The same data are in a .dbf table. If there is someone that could help me, please do!

    Thank you!

  2. #2
    Join Date
    Dec 2003
    Noida, India.
    You can use SQLLDR

    Other option can be stored procedure that reads file using UTL_FILE

    SQLLDR gives better performace.
    Oracle can do wonders !

Posting Permissions

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