title: Why does Oracle 12c query require double quotes around table
body: <p>The database I'm querying is Oracle 12c. Detailed info about database version is as follows:</p>
  
  <p>Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production</p>
  
  <p>PL/SQL Release 12.1.0.2.0 - Production</p>
  
  <p>I'm trying to eliminate the need to have double quotes around every view or table in my SQL query.</p>
  
  <p>Following works (from Oracle Sql Developer GUI)</p>
  
  <pre><code>select m."Metadata"
  from "EvMetadata" m
  </code></pre>
  
  <p>Following gives error (from Oracle Sql Developer GUI)</p>
  
  <pre><code>select m.Metadata
  from EvMetadata m
  </code></pre>
  
  <p>Error is</p>
  
  <blockquote>
    <p>ORA-00942: table or view does not exist
    00942. 00000 -  "table or view does not exist"
    *Cause:<br>
    *Action: Error at Line: 2 Column: 6</p>
  </blockquote>
  
  <p>I generated DDL, which looks like this</p>
  
  <pre><code>CREATE TABLE "EVP"."EvMetadata" 
  
  ("EvMetadataId" NUMBER(10,0) GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE , 
  
  "InsertDate" TIMESTAMP (6), 
  
  "SessionId" NVARCHAR2(17), 
  
  "FileCheckSum" NVARCHAR2(32), 
  "Metadata" NCLOB, 
  "Device" NVARCHAR2(20), 
  "User" NVARCHAR2(20)
  ) SEGMENT CREATION IMMEDIATE 
  </code></pre>
  
  <p>So based on @toddlermenot's comment below, it is very possible that this is how the table was created - with double quotes. I used ORM Entity Framework Code First to generate the schema for me so it seems like the ORM puts the double quotes by default.</p>