title: Reading JSON data from BLOB
body: <p>Edit - oracle version 19c</p>
  <p>I am uploading a json file using Browse file type in APEX and then storing it in a table as BLOB.
  The Table looks like this -</p>
  <pre><code>File_ID    Filename             Mime_type          created_on      blob_content
     1       file_new.json     application/json       9/1/2020           (BLOB)
  
  </code></pre>
  <p>Now i want to parse this and read the contents of blob as a table in oracle. How can i do it?</p>
  <p>The Json file looks like this but has hundred of rows.</p>
  <pre><code>[{&quot;Id&quot;:&quot;50021&quot;,&quot;eName&quot;:&quot;random123&quot;, &quot;Type&quot;:&quot;static&quot;,&quot;Startdate&quot;:&quot;07/03/2020&quot;,&quot;Enddate&quot;:&quot;08/02/2020,&quot;nominations&quot;:[{&quot;nominationId&quot;:&quot;152&quot;,&quot;nominationMaxCount&quot;:7500,&quot;offer&quot;:[{&quot;Id&quot;:&quot;131&quot;,&quot;Type&quot;:&quot;MONEY&quot;,&quot;clientId&quot;:41,
  &quot;stateExclusions&quot;:[],&quot;divisionInclusions&quot;:[&quot;111&quot;,&quot;116&quot;,&quot;126&quot;,&quot;129&quot;]]}]
  
  </code></pre>