SQL query

[ebrian]

This will work for you in 10g.

select regexp_substr(col_a,'[[:digit:]]+$') from test_exp
where regexp_instr(col_a,'#') > 0;

or

select regexp_replace(col_a,'(.*# )','\2') from test_exp
where regexp_instr(col_a,'#') > 0;