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.