How to concat table column value in Oracle LIKE query?

Question

select * from TableB where UserName LIKE "Here I want to search other table column value"

is it possible ?