Loading

How to concat table column value in Oracle LIKE query?

Priyanka K S

5y907SQL

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

is it possible ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
For subquery, you can use In or Exist operator instead of Like
select * from TableB where UserName In (Select username from tableA)
Ganesan C5y ago
Hi,

I think it is not possible to write subquery in the 'like' condition. Like condition accepts single string value and compare based on it.