title: Oracle SQL Syntax: Quoted identifier
body: <p>I encountered SQL queries that looked like</p>
  
  <pre><code>select "hello"
  from "foo"."bar"
  </code></pre>
  
  <p>I found that we can have quoted and unquoted identifiers in Oracle:
  <a href="http://download.oracle.com/docs/cd/E18283_01/server.112/e17118/sql_elements008.htm" rel="noreferrer">Database Object Names and Qualifiers </a></p>
  
  <blockquote>
    <p>... A quoted identifier begins and ends with double quotation marks ("). If you name a schema object using a quoted identifier, then you must use the double quotation marks whenever you refer to that object...</p>
  </blockquote>
  
  <p>I asked the DBAs and they told me that there is a table with name <strong>bar</strong> but not <strong>"bar"</strong></p>
  
  <p>Why is that?</p>