oracle substr(table),substr in Oracle from column

Most likely the simplest (and most performant) way of doing this would be to use the base string functions:

SELECT SUBSTR(col, INSTR(col, '#') + 1)

FROM yourTable;

We could also try using REGEXP_REPLACE here:

SELECT REGEXP_REPLACE(col, '.*#(.*)', '1')

FROM yourTable;

The regex option would in general not perform as well as the first query. The reason for this is that invoking a regex incurs a performance overhead. You might want to consider a regex option if you expect that the string logic might change or get more complicated in the future. Otherwise, go with base string functions wherever possible.