title: is possible : cast char to varchar while join table in oracle
body: <p>Can I cast <code>B1</code> <code>char(2)</code> which joins on <code>A1</code> <code>varchar2(2)</code> :</p>
  
  <pre><code>SELECT * FROM A 
    LEFT JOIN B 
      ON CAST(B.B1 AS VARCHAR2(2)) = A.A1  
  </code></pre>
  
  <p>It results to no errors, but there no data displayed.</p>
  
  <p>Is the above query possible? </p>