Hi Team,
We have a scenario where the end-user will zip the 05 CSV files and then upload it through ADF Application.
The ADF application takes this ZIPped file and stores it as a BLOB in Oracle Database ( we are using Oracle Cloud Database service ).
Once the zipped folder is available in DB in a Column as a BLOB, then I should be able to do below actions:
1. Take this BloB file and unzip to get the 5 CSV files inside it.
2. Insert the data from these CSV files into different DB Tables.
I have been checking the various forum and most mention the ZIP file being on a DB Directory / some file server.
In my case, the Zipped itself is in the BLOB.
Hope I could explain my case.
Please help with pointers.
Thanks,
Veena