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 |