How to lower case objects in Oracle database?
<p>Is there any way to name my Tables,Columns in the <code>Oracle DB</code> in lower case letters?</p>

<p>I search a lot and some recommendations say i should use double quotes in the creation like this :</p>

<pre><code>CREATE TABLE "test" (a number); 
</code></pre>

<p>The problem here is :</p>

<p>It forces me to decorate all my tables with <code>double quotes</code> through querying !</p>

<p>If i write :</p>

<pre><code>SELECT * FROM test ;  
</code></pre>

<p>I will get syntax error.</p>

<p>I want to  name all my tables , fields as lower case because i will use this in my model through <code>ORM</code> (Entity Framework) which use (<code>Pluralization and Singularization</code> ) feature , so  if i have Table like this :</p>

<p><code>CITY</code> according to Oracle convention .</p>

<p>The equivalent will be <code>CITY</code> entity and the pluralization as navigation property will be <code>CITies</code> !! </p>