i get few excel files via FTP server i want to save those files into my table in clob using plsql developer.
Asked
Active
Viewed 215 times
0
-
`CLOB` can't store binary data. If it is a simple csv file , you could use CLOB. Use `BLOB` or `BFILE` instead depending on your storage affordability – Kaushik Nayak Nov 27 '17 at 15:37
-
Since word, excel files are rar/zip files you could convert it to `base64` and then store it into a `CLOB`. [More Info](https://stackoverflow.com/questions/3804279/base64-encoding-and-decoding-in-oracle) – KALALEX May 31 '18 at 11:53