CODEWITHSUNDEEP
sqloracle-databaseplsqloracle-sqldeveloper
Jayanth Raghava
Jayanth Raghava

Reputation: 33

How to export a oracle table which consist of blob as a column in sql developer

I need to get a table data which consists of blob as a column, need to export as insert format.

create table table1
(id number,
document blob);

i tried using spool & /insert/ but i'm getting that column as null;

Upvotes: 1

Views: 12067

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22412

Use the sql loader format.

enter image description here

You'll get each blob downloaded as a file in the specified directory.

Bonus: use SQLcl from your command prompt to do the same using a bit of js

Upvotes: 4

Related Questions