Sometimes names will be written differently
For example :Chendra,Chandra,Chondra',But the name is same .
How to identify these names using SQL statements .
| pattern tells us to look for the letter "o", "e", or "a".
The Oracle REGEXP_LIKE condition example that we will look at involves using the
SELECT last_name FROM hr_contacts WHERE REGEXP_LIKE (last_name, 'Ch(o|e|a)ndra');
By using above expression we can acheive the expected results