title: PL/SQL split string, get last value?
body: <p>how could one split a string in PL/SQL to get the last value if the pattern look like this? :</p>
  
  <p>'1;2', in this case the value i want would be 2.</p>
  
  <p>Note: the splitter is the character ';' and values are of different length like '1;2 or 123;45678 etc...'</p>
  
  <p>Thanks in advance!</p>