Open

How to export blob data from multiple rows in oracle into multiple files on local machine

The table in oracle database has :

FileName FileType Data

abc.xlx excel blob

def.pdf pdf blob

This database is hosted on a central server. I want to extract this data from multiple rows into multiple files. If I try doing it through SQL developer, I can do it for one row at a time. Is there any way to can be done for multiple rows?

UTL_FILE stores the files on the database server. But I want to store them on my machine.

Can it be done by a stored procedure? Or should a Java utility be written?