title: Decode in insert statement
body: <p>I have many columns in table of which 2 columns are<br>
  A : number
  B : varchar</p>
  
  <p>I am trying to insert value in B based on value of A from java.</p>
  
  <pre><code>insert into table(A,B) values (? , decode('A',110,'ABC',NA));
  </code></pre>
  
  <p>this gives me an error : <code>illegal number</code></p>
  
  <p>So i tried the below : </p>
  
  <pre><code>insert into table(A,B) values (? , decode('A','110','ABC','NA'));
  </code></pre>
  
  <p>This always inserts <code>NA</code> in the column.</p>
  
  <p>Can someone please help me with this ?</p>