title: Joins with columns being joined have different lengths
body: <p>Suppose I have two tables,</p>
  
  <pre><code> - emp(empId number(1),empName varchar2(50)) and
   - manager(manId number(5),managerName varchar2(100))
  </code></pre>
  
  <p>And I fire a query - </p>
  
  <pre><code>select * from emp e,manager m where e.empId = m.manId; 
  update emp set empName= (select managerName from manager where manId='2');
  </code></pre>
  
  <p>Will there be any problem in this sql as length of empName and managerName is different? </p>