Joins with columns being joined have different lengths

Suppose I have two tables,

 - emp(empId number(1),empName varchar2(50)) and
 - manager(manId number(5),managerName varchar2(100))

And I fire a query -

select * from emp e,manager m where e.empId = m.manId; 
update emp set empName= (select managerName from manager where manId='2');

Will there be any problem in this sql as length of empName and managerName is different?

Answers


First will work (well, not raise an error), second will raise an error if length of managerName > 50.

It would work with substr(managerName, 0, 50) and

WHERE empId = 2

at the end.

By the way, you could have tried !


Need Your Help

How could I hide the Street Address whole div block and only show the Company block?

javascript jquery css

I am not able to change the parent div tag names (div class="pc_flex_form_line_container")

.NET Multiple Class Library in One Library

c# dll reference

I am working in VS2008. I have a custom class library (CL1) which references another custom class library (CL2). This ends up having CL1 and CL2 in my release folder. Now the consumer of CL1 needs to