By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (value) AS
SELECT ',7809628#465797,7809628#461396,' FROM DUAL;
1 rows affected
SELECT SUBSTR(value, hash1 + 1, comma2 - hash1 - 1)
|| ',' ||
SUBSTR(value, hash2 + 1, comma3 - hash2 - 1) AS parsed_value
FROM (
SELECT value,
INSTR(value, '#', 1, 1) AS hash1,
INSTR(value, '#', 1, 2) AS hash2,
INSTR(value, ',', 1, 2) AS comma2,
INSTR(value, ',', 1, 3) AS comma3
FROM table_name
)
| PARSED_VALUE |
|---|
| 465797,461396 |