title: How to use apex_string.split?
body: <p>I'm trying to split a string : <code>OK#15#78</code> by #</p>
  
  <p>I would like to get the first part of the string : Ok</p>
  
  <p>I tried the following queries but it's not working : </p>
  
  <pre><code>select apex_string.split('OK#15#78','#')[0] from dual;
  </code></pre>
  
  <p>Can anyone help please ?</p>
  
  <p>Cheers</p>