title: Split a string based on hyphen
body: <p>I have a string like this</p>
  
  <pre><code>XX0099-X01
  </code></pre>
  
  <p>I would like to split the string into two based on the hyphen, i.e.
  <code>XX0099</code> and <code>X01</code></p>
  
  <p>I have tried as</p>
  
  <pre><code>SELECT 'XX0099-X01',
             SUBSTR('XX0099-X01',
                    1,
                    INSTR('XX0099-X01',
                          '-',
                          1
                          ) -1
                    )
      FROM   dual
  </code></pre>
  
  <p>Not sure how to get the second part. </p>
  
  <p>We have an old legacy system which still using 8i Oracle database.</p>