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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to load all files in a directory into Oracle table

139186Jul 6 2009 — edited Jul 10 2009

Hi All,
I have a directory on my Oracel server where I have thousands of files (.doc, .ppt, .xls, .txt and .pdf).
I need to load them all into table (into a BLOB column) and based on the file extention I need to set the file_type
column which is a varchar2. How can I do this?

Thanks in advance,
Asha

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2009

Added on Jul 6 2009

5 comments

3,275 views