Skip to Main Content

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2018
Added on Jul 21 2018
1 comment
1,807 views