Oracle LIKE

The Oracle LIKE operator specify a test involving pattern matching.

Oracle LIKE example

Select *
From customers c 
Where c.name Like '%CORPORATE%';

Select *
From customers c 
Where c.name Like 'CORP%';  -- begin with CORP

Select *
From customers c 
Where c.name Like '%CORP'; -- end with CORP

Select *
From customers c 
Where c.name Like '_C%';  -- second letter start with C

Select *
From customers c 
Where c.name Not Like '%CORPORATE%';

Select *
From customers c 
Where upper(c.name) Like '%CORPORATE%';