title: Find a string within the source code (DDL) of a stored procedure in oracle
body: <p>I need to find a string in the source code (DDL) for all stored procedures in Oracle schema.</p>
  
  <p>I use this query to perform the task, but I think can be improved</p>
  
  <pre><code>SELECT T0.OBJECT_NAME
  FROM USER_PROCEDURES T0 
  WHERE T0.OBJECT_TYPE='PROCEDURE'
  AND INSTR( (SELECT DBMS_METADATA.GET_DDL('PROCEDURE',T0.OBJECT_NAME,'MySCHEMA') 
              FROM DUAL), 'TheStringToSearch' )&gt;0
  </code></pre>
  
  <p>is there a way of accomplishing this task in a more optimal and fast way?</p>
  
  <p>thanks in advance.</p>