title: Oracle - extract images from BLOB
body: <p>I'm really green. I want to extract images (JPGs) from Oracle PDB. Table Looks something like this:</p>
  
  <pre><code>select * from BOB.USER_ID t
  
  
      LINK_ID     ID_SCAN
  1  340101001    &lt;BLOB&gt;...
  2  340101002    &lt;BLOB&gt;...
  3  340101003    &lt;BLOB&gt;...
  4  340101004    &lt;BLOB&gt;...
  5  ...
  </code></pre>
  
  <p>If possible, I want to extract them, with LINK_ID names (340101001.jpg).</p>
  
  <p>I can extract them one-by-one, but there are ~5000 images... I would love to do it with some command or something...</p>
  
  <p>I've looked for solution, but things that I could understand a little, they didn't work.</p>
  
  <p>Thank you and sorry for inconvenience.</p>
  
  <hr>
  
  <p>I tried to do "cart" method,? but it didn't work out. I couldn't open files that were extracted. I also tried third-party software, OraLobEditor.
  Other then that, I could not understand codes and commands, I found in internet.
  I'm trying to use SQL and PL/SQL Developer.</p>