title: Query to extract the word from string
body: <p>I want to extract words from a  Address field (Oracle 12 C) containing the below address :-</p>
  
  <p>str1: <code>Abc.. Flat no - 8956, 8th road , Scramendo 4th street,Portland.</code><br>
  str2: <code>Abcd.. Flat no Ad- 3434/89/69 Scramendo 4th street,Portland.</code></p>
  
  <p>My query should return </p>
  
  <ol>
  <li><code>Flat no - 8956.</code>  (From str1 )</li>
  <li><code>Flat no Ad- 3434/89/69</code> (From str2) </li>
  </ol>
  
  <p>Basically I want to extract the flat no from the string in huge set of data rows</p>