Results 1 to 2 of 2

Thread: UTL_FILE Package (Retrieving Flat File data and inserting into Oracle DB Tables)

  1. #1
    Join Date
    Mar 2004
    Posts
    4

    UTL_FILE Package (Retrieving Flat File data and inserting into Oracle DB Tables)

    Hi,

    I am looking for some code. Pls help me if you can.

    Retrieving data from Flat Files (CSV) and inserting into Oracle 9i Data Base using UTL_FILE Package.

    Example Data : 123, abc

    This data should be inserted in oracle data base table as seperate fields (code, name)


    Thanks

  2. #2
    Join Date
    Mar 2009
    Posts
    1
    Hi,
    please use UTL_FILE utility from oracle .
    use utl_file.fopen the file from the directory where you saved yours.
    check for the delimeter in the file.
    use oracle instr and substr to segerate the values.
    and then you can easily insert into the tables.

Posting Permissions

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