Oracle fuzzy inquery, using ignore case.

Here is an example:

 

Prepare data:

Create Table fruit

(

ID number (4) primary key,

Name varchar2 (150)

);

 

Insert into fruit (ID, name) values (1, 'apple ');
Insert into fruit (ID, name) values (2, 'bana ');
Insert into fruit (ID, name) values (3, 'pear ');
Insert into fruit (ID, name) values (4, null );

 

Commit;

 

Select ID, name from fruit;

 

Here is the output:

 

ID name

1PPle

2 banana

3PEar

4 null

 

Select ID, name from fruit where lower (name) like '% P %'; ('% P %', P isminuscule here .)

Or

Select ID, name from fruit where upper (name) like '% P %'; ('% P %', P is capitalized here .)

 

Here is the output:

 

ID name

1PPle

3PEar

 

From the result, you can see if the value of name column containscharacter 'P', No matter 'P' is
Minuscule or capitalized,

That record will be listed in the query result.