title: Split string in PLSQL
body: <p>Following should return Y</p>
  
  <pre><code>CASISA#Y
  
  INVOPT#LUMREG#LUMSUM#2000#REGSUM#8000
  
  LUMSUM#2000#REGSUM#8000
  </code></pre>
  
  <p>i.e Hash separates Code and Value and it also separates Code, Value pairs (earlier semicolon used to separate Code, Value pairs)</p>
  
  <p>Following should return N (as these are incorrect input string formats)</p>
  
  <pre><code>CASISA#
  
  INVOPT#LUMREG#LUMSUM
  
  LUMSUM#2000#REGSUM#8000#
  </code></pre>