Oracle 11g Release 2

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

CREATE TABLE test (id INT, txt VARCHAR2(255));
INSERT INTO test VALUES (1, 'Q;W;R;T;TY')
1 rows affected

INSERT INTO test VALUES (2, 'Q;W;R;TT;TY')
1 rows affected

SELECT id, txt, INSTR(';' || txt || ';', ';T;') is_present
FROM test


ID
TXT
IS_PRESENT


1
Q;W;R;T;TY
7

2
Q;W;R;TT;TY
0