title: Oracle 12c JSON Query Issue with Dot Notation and Double Quotes
body: <p>I have a table "EvMetadata" with column "Metadata" that has a check constraint of "IS JSON". Note that the table and its columns are created with DOUBLE QUOTES by design.</p>
  
  <p>Following SQL works where I'm not specifying any JSON work to be done by Oracle.</p>
  
  <pre><code>select 
    m."Metadata"
  from "EvMetadata" m
  </code></pre>
  
  <p>As you can see below, the Metadata column simply displays its content which happens to be JSON data.</p>
  
  <p><a href="https://i.stack.imgur.com/49zmH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/49zmH.png" alt="Showing content of &quot;Metadata&quot; column which is JSON"></a></p>
  
  <p>However, I get error if I were to issue a json query as follows.</p>
  
  <pre><code>select 
    m."Metadata"."FileName"
  from "EvMetadata" m
  </code></pre>
  
  <p>I just added "FileName" using dot notation. As you can see above, "FileName" is a valid json field. So why the error?</p>
  
  <p>Error is</p>
  
  <blockquote>
    <p>ORA-00904: "M"."Metadata"."FileName": invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action: Error at Line: 2 Column: 3</p>
  </blockquote>
  
  <p>Could this be a bug with Oracle's JSON query support using the dot notation under a specific scenario where database objects are declared with double quotes? The reason I suspect that may be true is that the following equivalent query, not using the dot notation, works.</p>
  
  <pre><code>select 
    JSON_VALUE(m."Metadata", '$.FileName')
  from "EvMetadata" m
  </code></pre>