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!

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,341 views