Regarding ur other query,
why not use the decode directly?

decode(A,3,decode(B,10,null,'mgr'||C))


?
-venu.