Total Pageviews

July 17, 2021

7/17/2021 11:56:00 AM

Sometimes names will be written differently 

For example :Chendra,Chandra,Chondra',But the name is same .

How to identify these names using SQL statements .

The | 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 | pattern.
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
Related Posts Plugin for WordPress, Blogger...