Matching query [message #664240] |
Mon, 10 July 2017 00:31 |
|
mvrkr44
Messages: 132 Registered: December 2012
|
Senior Member |
|
|
Table:
-----
Create table test(id number,name varchar2(250));
insert into test(1,'rajesh kumar reddy');
insert into test(2,'rajesh kumar mudimela');
question:I need a query which will give both records if i pass the string as "rajesh mudimela reddy".
if any minimum two exact words is matching then needs to give the result
my input parameter is "rajesh mudimela reddy"
output should be: 1,rajesh kumar reddy
2,rajesh kumar mudimela
[Updated on: Mon, 10 July 2017 00:32] Report message to a moderator
|
|
|