title: get last number part of a String in PL/SQL
body: <p>In PL/SQL, is there any way to calculate next serial number from another one like 'A1B0010C'. Next serial no will be A1B0011C (+1). My idea is retrieve number part, increase it get return string back. 
  I can do this in java, but passing more than 1000 elements to Oracle will cause problems in IN clause. 
  So please help, any suggestion is appreciated.</p>