Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tab1(i INT PRIMARY KEY, name VARCHAR2(100));
INSERT INTO tab1(i, name) VALUES (1, 'John');
1 rows affected

INSERT INTO tab1(i, name) VALUES (2, 'Joe');
1 rows affected

INSERT INTO tab1(i, name) VALUES (3, 'Billy'); 
1 rows affected

SELECT /*csv*/ *
FROM tab1
WHERE name = 'jOHN' ;
SELECT /*csv*/ *
FROM tab1
WHERE name COLLATE BINARY_CI = 'jOHN' ;


I
NAME


1
John


SELECT /*csv*/ *
FROM tab1 
WHERE name LIKE 'j%';
SELECT /*csv*/ *
FROM tab1 
WHERE name COLLATE BINARY_CI LIKE 'j%';


I
NAME


1
John

2
Joe