title: regular expression clob field
body: <p>I have a question related to an regular expression in oracle 10.</p>
  
  <p>Assuming I have a value like 123456;12345;454545 stored in a clob field, is there a way via an regular expression to only filter on the second pattern (12345) knowing that the value can be more then 5 digits but always occurs after the first semicolon and always has a trailing semicolon at the end?</p>
  
  <p>Thanks a lot for your support in that matter,</p>
  
  <p>Have a nice day,</p>