SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Loader or UTL_FILE , Which is better ??

518258Jul 26 2007 — edited Jul 27 2007

Hello All,

In my system I have to Download the data from a file each day in some table.
The file is of fixed format. And the number of records (lines) in the file is not more than 1000 (say) each day.

I would like to know for such scenario what will be better to use, SQL Loader or UTL_FILE package to read the file?

DB - Oracle Database 10g on Linux platform.

Thanks & Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2007

Added on Jul 26 2007

15 comments

1,921 views