Oracle Tutorial

Like Operator Examples

Example 1

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

Example 2

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

Example 3

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



Example 4

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

Example 5

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

Example 6

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