title: How to avoid " " in select statement in column name for column that has numberAlphabet pattern in Oracle?
body: <p>I have doubts regarding double quote column name in Oracle. I tried creating column name in number_alphabets pattern but this won't work. Then I used double quote and I was able to create table with this column name. When I do select, column name comes within double quote.
  I have attached script in here.</p>
  <pre><code>CREATE TABLE test 
  (       
    &quot;100_title&quot;     VARCHAR2(200) NULL  
  )     
              
  SELECT * FROM test 
  </code></pre>
  <p>When I do select, in result set, column name will be &quot;100_title&quot; but I do not want &quot;&quot; in it. Is there a way to fix this?</p>