VP3 - Art & Design and HS5 - Health & Social Care, I need to get string after
'-' in Oracle. Can this be achieved using substring?
For a string operation as simple as this, I might just use the base
SUBSTR() functions. In the query below, we take the substring of your column beginning at two positions after the hyphen.
SELECT SUBSTR(col, INSTR(col, '-') + 2) AS subject FROM yourTable
We could also use
REGEXP_SUBSTR() here (see Gordon’s answer), but it would be a bit more complex and the performance might not be as good as the above query.