Techiio-author
Started by Jake WiliamsSep 22, 2021

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

0 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWES SHARE

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

You must be Logged in to reply
Trending Technologies
15
Software40
DevOps46
Frontend Development24
Backend Development20
Server Administration17
Linux Administration26
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance