By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select
ltrim(
regexp_replace(
',7809628#465797,7809628#461396,'
,'[^#]*#(\d+?),'
,',\1')
,','
) new_str
from dual;
| NEW_STR |
|---|
| 465797,461396 |