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!

Unzip BLOB column and load each file in another table BLOB column

vis1985Jul 21 2018 — edited Jul 21 2018

Hi,

I have one table tab_file with 3 column as below.

Tab_file
File_id	File_name	file_data
1	finance.zip	BLOB

In file_data column zip file present and in each zip file there are multiple documents like word,pdf,excel etc.

I have to unzip this zip file present in blob column and load each file in separate table - Tab_file_unzip in another blob column like below using PLSQL.

Tab_file_unzip
File_id	File_name	File_unzip_name	File_unzip_data
1	finance.zip	abc.doc	BLOB
1	finance.zip	xyz.pdf	BLOB
1	finance.zip	pqr.xls	BLOB

Please let me know if anyone done like this before.thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2018

Added on Jul 21 2018

1 comment

1,810 views