By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE invoices (ID, SYMBOL, COST_IDS) AS
SELECT 1, 'FV01', '1076219, 1081419' FROM DUAL UNION ALL
SELECT 2, 'FV02', '107621,123421' FROM DUAL UNION ALL
SELECT 3, 'FV03', '111521; 107621' FROM DUAL;
3 rows affected
SELECT *
FROM INVOICES
WHERE REGEXP_LIKE(COST_IDS, '(^|\D)107621(\D|$)')
| ID | SYMBOL | COST_IDS |
|---|---|---|
| 2 | FV02 | 107621,123421 |
| 3 | FV03 | 111521; 107621 |