Need Fuzzy logic with Regular expression query [message #602544] |
Thu, 05 December 2013 09:10 |
|
mvrkr44
Messages: 132 Registered: December 2012
|
Senior Member |
|
|
I have table like Usernames
create table usernames(first varchar2(250),second varchar2(250),third varchar2(250),fourth varchar2(250),fifth varchar2(250)).
insert into usernames values ('sachin','ramesh',null,null,'tendulkar');
insert into usernames values ('sachin','tendulkar',null,null,'ramesh');
insert into usernames values ('sachin',null,null,null,'tendulkar');
insert into usernames values ('sachin','ramesh',null,tendulkar,null);
insert into usernames values ('sachin','ramesh','tendulkar',null,null);
insert into usernames values ('sachin','ramesh',null,null,null);
Now i need to get the names need to serach against the concatination of first || second || third ||fourth || fifth
Need the below logic
1.^AB.*C.*D.*E.*$
2.^A(B)?(C)?(D)?(E)?$
3.^BA$
4.^DBA$
|
|
|
|