title: Search for a particular string in Oracle clob column
body: <p>How to get a particular string from a clob column?</p>
  
  <p>I have data as below which is stored in clob column called <code>product_details</code></p>
  
  <pre><code>CALCULATION=[N]NEW.PRODUCT_NO=[T9856] 
  OLD.PRODUCT_NO=[T9852].... -- with other text
  </code></pre>
  
  <p>I would like to search for string <code>NEW.PRODUCT_NO</code> from column <code>product_details</code></p>
  
  <p>I have tried as</p>
  
  <pre><code>select * from my_table
  where dbms_lob.instr(product_details,'NEW.PRODUCT_NO')&gt;=1
  </code></pre>
  
  <p>The above fetches full text from my table.</p>
  
  <p>Any help is highly appreciable.</p>
  
  <p>Regards</p>