Hi Team,
I have the data like this.
create table employees (ename varchar2(1000), deptno number);
insert into employees values('john,smith',10);
insert into employees values('alex',10);
insert into employees values('king,smith,alex',10);
insert into employees values('mike,steve',20);
select * from employees;
here I'm passing comma separate values to the column 'ENAME' like 'smith,chris'.
select * from employees where ENAME in (:P_ENAME); -- ('smith,chris')
My requirement is that if any of the names we are passing match it should return that string.
eg: If I pass the string 'mike,alex' to P_ENAME then it should return below records
king,smith,alex
alex
mike,steve.
Can you suggest a solution for this?
Thank you.