title: How to match the chracters with # in oracle query
body: <p><strong>Incident Table</strong></p>
  
  <p>I have Incident Table like below i need to match the client list in client table. How can i do that in oracle ?</p>
  
  <pre><code>INCIDENT_ID |CLIENTS_LIST     |
  ------------|-----------------|
  56          |A001##A05M##A0AS |
  </code></pre>
  
  <p><strong>Client Table</strong></p>
  
  <pre><code>BO_NAME               |COMPANYID
  ----------------------|---------
  Test1                 |A001     
  Test2                 |A0AS     
  Test3                 |A05M      
  Test4                 |A0BT     
  </code></pre>
  
  <p>Im trying to match the companyid with clients_list but there is no result.</p>
  
  <p><strong>Tried Query</strong></p>
  
  <pre><code> SELECT DISTINCT INCIDENT_ID,
                   CLIENTS_LIST,
                   REPLACE(CLIENTS_LIST, '##', ',') AS client_id,
                   cl.BO_NAME,
                   COMPANYID
     FROM incident ir 
     INNER JOIN Client cl
       ON  cl.companyid IN (REPLACE(CLIENTS_LIST, '##', ','))
  </code></pre>
  
  <p><strong>Expected Output</strong></p>
  
  <pre><code>BO_NAME               |COMPANYID
  ----------------------|---------
  Test1                 |A001     
  Test2                 |A0AS     
  Test3                 |A05M      
  </code></pre>