Archive for the ‘delete external file in SQL’ tag
The trick for making a BFILE read-write or at least read-delete
A while back, I demonstrated how you can read a file directory from SQL. Here’s how you can delete an external file referenced by a BFILE
column. There’s only one problem with this level of the architecture, there’s no rollback. However, it does let you delete the external file when you want to delete the column value.