Skip to Main Content

APEX

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!

Convert BLOB into a table

481088Jan 13 2006 — edited Feb 10 2006
Hey,
I have a problem....

I am using the new Oracle XE and I want to load Excel Data (.xls) in an application which converts the Excel Data into an existing table.

My idea is, to load the excel form (.xls) into the file_subject table and after uploading the file the BLOB should be convert into the existing table. And the different columns should have different data types (VARCHAR2,NUMBER,DATE)

Has anyone an idea?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2006
Added on Jan 13 2006
5 comments
1,069 views