Can you please let me know if I can concatenate 3 columns(2 integer type and 1 char type) and the result of combination to be used as where condition of in sub query. It should be like below. I am getting error when I use the below query.
Select * from table1
(column1 || column2 || Column3) not in
( Select (column1 || column2 || column3) from table1
where column4 not in ('A' , 'B')) with ur;