title: Oracle search array within JSON values?
body: <p>I have the following stored in an Oracle database as JSON:</p>
  
  <pre><code>{
     value: [1,2,3]
  }
  </code></pre>
  
  <p>The value can be of any type (strings, integers or arrays). How would I query if the type is array and if it contains a certain value?</p>
  
  <p>In pseudocode:</p>
  
  <p><code>SELECT * FROM TABLE WHERE COLUMN_NAME.value CONTAINS 2</code></p>
  
  <p>I can see how to query strings using Oracle functions such as <code>json_query</code> but cannot see how to run this specific type of query without selecting all data and searching on the client.</p>