Subscribe to Green-Card-Lottery's Blog        RSS Feed
- - - - -

PL/SQL: Write Oracle BLOB images to Image files

Icon Leave Comment
If you have a BLOB image table and you want to dump all images to file, this routine will do the trick.
We have a table blob_image_table with the following columns:
image_name varchar2(128)
image_extension varchar2(128)
image_blob BLOB

First create the directory physically on disk, then
as sysdba execute the following commands,
where your_schema...

Page 1 of 1

February 2022

S M T W T F S
  12345
67 8 9101112
13141516171819
20212223242526
2728     

Tags

    Recent Entries

    Search My Blog

    2 user(s) viewing

    2 Guests
    0 member(s)
    0 anonymous member(s)