Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: When to use SQL Loader and when UTL_FILE package to extract file?

    When to use SQL Loader and when UTL_FILE oracle/package to extract data from the file into oracle. Though functionality of the UTL_FILE and SQL Loader are same.

  2. #2
    Join Date
    Aug 2003

    UTL_FILE is an package for reading or writing files. SQL Loader is a tool to load files into the database. Since UTL_FILE functions can also read files, either could be used to load data. which one to choose depends on your requirement. If a simple load, choose loader, if you want to process your text file or do something more complex before loading, use utl_file. SQl loader commands are pretty extensive to suit most of your needs.


Posting Permissions

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