title: Split string into two columns (SQL or PL/SQL)
body: <p>I need to split a string from one table into two columns in another table. There are a few different variety of numbers and rules but no clear delimiter. Can I use combo of SUBSTR and INSTR or do I need to use if-then loops in PL/SQL to satisfy all the rules?</p>
  
  <p>Input Table</p>
  
  <pre><code>5 Kent Street 
  3 A lindt Street
  2/15 bold Street 
  9/34-36 carmen Road
  12/5a sandford Street
  </code></pre>
  
  <p>Result</p>
  
  <pre><code>Number  |Street
  --------------------
  5       |Kent Street
  3A      |lindt Street
  2/15    |bold Street
  9/34-36 |carmen Road
  12/5a   |sandford Street
  </code></pre>