Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    2

    Unanswered: Inserting data from .csv file into Oracle 8iLite

    Hello,

    What's the correct command for reading data from a file and inserting it into a table?

    I've tried using "input data infile "e:\data\city.csv" into city(zip_code, city_name);" which completes with no error but doesn't put my data into the table.

    Please tell me what I'm doing wrong. Thanks.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    is a program called sqlldr available with Oracle 8i lite?
    this program is designed to take flat files and load their data into oracle tables ..

  3. #3
    Join Date
    May 2003
    Posts
    2

    sqlldr

    I don't believe so. I was, however, able to get it to load through Oracle Navigator. Go figure. Thanks for taking the time to reply.

Posting Permissions

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