title: Why inserting varchar2 for number works in Oracle database?
body: <p>I don't understand how can we insert a <code>varchar2</code> data into a column with a datatype of <code>number</code>. </p>
  
  <p>Consider following sequence of queries:</p>
  
  <pre><code>create table aniket.test(id number);
  
  insert into aniket.test(id) 
  values ('1');
  
  select * from aniket.test;
  </code></pre>
  
  <p>It works fine though I am using quotes. How does it work? Is <code>varchar2</code> internally converted to number?</p>