title: How to insert a picture into BLOB column in Oracle table using INSERT syntax?
body: <p>I have a simple table where I want to insert an image that exists on my machine.I would like to insert the picture into my table's BLOB column. Just wondering how can I do it. I understand that there are some existing solutions which are related to BLOB but none have helped me directly by using INSERT SYNTAX.</p>
  
  <pre><code>CREATE TABLE test(id int,photo BLOB);
  
  INSERT INTO test VALUES(1,'Path of the picture\filename');
  </code></pre>