PL/SQL split string, get last value?

Question

how could one split a string in PL/SQL to get the last value if the pattern look like this? :

'1;2', in this case the value i want would be 2.

Note: the splitter is the character ';' and values are of different length like '1;2 or 123;45678 etc...'

Thanks in advance!

Answer 1

SELECT SUBSTR( column_name, 
               INSTR( column_name, ';', -1 ) + 1 )
  FROM table_name

should work. Here is a SQL Fiddle example.