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?
0 Replies